How to have Page Tabs focus on record.

[Greycom4]

I'm trying to setup a database that has multiple page tabs to disply information held in multiple tables.


Each table has a common PK that appears in every table for each Customer. I would like to be able to setup a search box in the first page tab to search for a specific Customer ID and then
click on each tab to view the details relating to the searched key. So for example search on a known Customer ID and then click on the Customers Tab, Customer orders Tab, Customer payments Tab, Customer Returns Tab and see each record without having to search again. Any help / advice would be most welcome.

Thanks

[RuralGuy]

Each tab should have a SubForm on it. That will allow each tab to look at a different table if you want. Your "Search" should be on the main form and not the tab control. Each SubFormControl should have their LinkMaster/ChildFields properties set to the PK returned in your search. The LinkMasterFields property should point to the control on the Main Form that contains the value.
In re-reading your post, are you saying that each table has the same PK value as the PK for the table?

[Greycom4]

Thanks for your reply RuralGuy. Your suggestion is making sense and you are correct that many (not all) of the tables are related through a unique number (similar to a National Insurance Number). I also have a number of 'many 2 many' and 'one 2 many' tables but these would not form part of the Page Tab requirement.

Each SubFormControl should have their LinkMaster/ChildFields properties set to the PK returned in your search

.

I'm familiar with the LinkMaster/ChildField, but can you explain how I can acheive this, do I need to write some VBA to make this happen ? Really appreciate you help on this.

[RuralGuy]

The SubFormControl has two special properties called LinkMasterFields and LinkChildFields that can keep a MainForm on which it resides and the SubForm that it is displaying synchronized. If these two properties point to values on the MainForm (LinkMasterFields) and SubForm (LinkChildFields) that the two forms have in common then the SubFormControl will match them up for you with no code involved.

[Greycom4]

Hi, i thought I had updated the post. Just wanted to thank you RuralGuy for your explanation and assistance which was spot on and works really well.
Cheers.

[RuralGuy]

You're very welcome.