Hi,
Im wondering the basic structure on how to open a record from a main table when i do a search in a related table.
Setup:
I have two tables main and cases
The main table is displayed in the mainForm and the cases table is related by a mainID
How would i do a search in the cases table and then display the related record in the main form.
Basically i would love to have the find dialog box but an option to choose linked tables and then do an overall search for that table..
Thx
Zozew
Im wondering the basic structure on how to open a record from a main table when i do a search in a related table.
Setup:
I have two tables main and cases
The main table is displayed in the mainForm and the cases table is related by a mainID
How would i do a search in the cases table and then display the related record in the main form.
Basically i would love to have the find dialog box but an option to choose linked tables and then do an overall search for that table..
Thx
Zozew