How to Filter multiple unrelated tables?

[ggk]

Win10 64 LO 7.3.7.3 Hsql 2.61

Hello,

A research database contains a number of unrelated tables aka Todo, Notes, Lists, WebDocs,…

Now I might want to search/filter for any records of Joe Bloggs in any of these tables. Have done some quick mockup using 4 tablecontrols on a form and a button which does a .uno:Recsearch. as shown in the screendump

Trouble is the Search dialog is far too big and one needs to manually switch between the forms within the search.

Now an alternative could possibly be a textbox filtering a subform using an sql statement using parameters, upper, etc. with a filter table.
But is it somehow possible to tie 4 tablecontrols to the same textbox in order to produce simultaneous filtering?

Any other way of doing it ? Thanks for your thoughts.

[RobertG]

You will need a Filter table. Searching and filtering with the internal dialogs of a form will only work in in one form. Subforms will also be ignored as other parallel created forms.

Datasource of every form must be created by a query, which reads the value you are looking for in the Filter table.

Also you will need to create a little macro, which should save the data for the Filter table and will reload all four forms you created for the table controls.

[ggk]

Thank you Robert, got it working !