Hi Michael

Thank you for reaching out to us.

If I understand correctly this can be achieved with the Cascade filtering feature of our paid Powerful Filters addon. You would create a table with all the necessary data, select the filtering option from the columns' settings to be a Selectbox and turn on Filters in a form option from the Sorting and filtering tab. 

Then turn on Cascade filtering from the Sorting and filtering tab. This will display a value in the selectbox related only to the previously selected criteria. You can choose which columns are included in the filters from each column's settings.

As for the Advanced Custom Fields you would need to create a custom query that'd return the data you need. Using our query constructor pulls the data from WordPress database, but ACFs data can also be stored in the MySQL database, so try using that generator.

We cannot help you with the custom query, though, as included support doesn't cover custom queries, and we don't have native integration with ACF, so you'd need to locate the data you need in the database, and then pull it using that custom query.

Do let us know if there is anything else we can assist you with.