Tables with sub sub sub forms (How to cascade link them on tab navigation form?

[Tjabooo]

How to link several serial subforms to different tab´s

I have this structure:



And I want this one:


I have no problem with continous forms and I manage to get them all related.

I need to achieve the same with tabs.


I want to start with the customer and then click next tab = CustomerArea
fill that one and continue to the next = CustomerSystem and so on.

How on earth can I do that, tried everywhere to get an ansver.

Reguards // Dick S Stockholm

[June7]

Is this what you want http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

[Tjabooo]

I´m such a newbie so I think I would not see it even if someone put it in my mouth, especially after sitting 3 days from morning to late evening.

I tried to make continues forms wich I successsfully made by making several forms and then put one after the other inside each other.
That worked out nice and neat.

In tabs:
I also managed to put the main form on the first tab, and the second on tab no 2
So I could click and schooze customer on the first tab and then go to the next tab and se that customers different areas.
when i looked at the linking field on those two first forms it made sence, on the second form i could link to the main forms primary key and to it´s own foreign key.
BUT, when i did the same with the third form, and wanted to link that one with the "middle subform" I could only see the mainform.

Anyhow, Thank you for helping, I will try to have a look att that one tomorrow when my brain is ready to take moore info, right now it´s only magma left.
Reguards // Dick S Stockholm Sweden

Is this what you want http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp