Grant, in case you are still working on this, I just built a simple shortcode plugin roughly to your requirements, except for the data source. It sounds like you have that piece covered with a backend Airtable API process*. I faked a data source with...

In case you are still trying to solve this, the way I would approach it is to have a client table, plus 20 reporting tables. The client table joins the marriage table with a unique client key, such as social security number. Likewise divorce table jo...