If those tables are properly associated with each other in the data model then selections will propagate over all those tables. Every object in your document will directly reflect your selections.
If that doesn't happen then either your data model is wrong or you have very good reasons to have tables that are totally unrelated to each other. In that case you need to use dark gray magic to make a selection in a field of one table apply in a field in another table too.
The dark gray magic is called Select in Field actions. Actions can be assigned to buttons and text boxes and triggers. You can find the triggers on the Triggers tab in the Document Properties window.
Currently, I have have filters using wildmatch which are looking within a specific column and a specific table. These tables are separated for good reason, but I would like to be able to apply these filters to the same column and multiple different tables.
Do you think you could help me better understand how to use the select in field actions for this purpose? Thank you so much for your help!