Linking several tables on Tabbed Form ?

[Tjabooo]

Hello !

I tried to find this information in several books and online.

Objective:
I want to have a navigation Form where the top tab will show the main Customer, and in the same tab also a sub table with chosen contact information.

With that top tab chosen, I want to chose left tab wich shall open (in this example)
the phone number of that contact.

I provide a PDF w
ith a few pictures of tables, relationships and how I want the forms to look.
A picture tells thousands word...

Thank you anybody.

 

[Tjabooo]

So far I had like 30 views.. but no answer

should I have psoted this one else where or did I do bad explanation ?

 

[spikepl]

It is not clear what the issue is. The way to synchronise multiple subforms together on the same form does not depend on whether they are wrapped in tabs or not. What, very specifically, are you stuck on?

 

[Tjabooo]

It is not clear what the issue is. The way to synchronise multiple subforms together on the same form does not depend on whether they are wrapped in tabs or not. What, very specifically, are you stuck on?

Thanks for your reply.

The the top tab:
Contains the parentform ContractorCompany
So I first want to choose Company.
and then Contact (from the subform "ContractorContacts")

Then when I click on the left side tab, named "ContractorPhone"
I want to see all the phoneNumbers from the Contact I chosed.

Thanks again.
The basic problem is: how to link/connect them together.

 

[spikepl]

http://www.fmsinc.com/microsoftaccess/forms/synchronize/linkedsubforms.asp

 

[Tjabooo]

Thank god, or I mean, Thank you soo very very much.

I just speed read the text and it seems to be the "thing" i need.
To late to try now, bur for sure I tell you if it works.