link Child/Master fields from a subform within a subform

[DiscombobulatedDuck7]

Hi,


i have a master form called PERSON. Within this form there is a tab control with 2 subforms, FRIENDS (tab1) and CO-WORKERS (tab2). FRIENDS contains a tab control of its own with 2 subforms, HOBBIES (tab1-1) and ACTIVITIES (tab1-2).


How do I link the two subforms from tab1-1 and 1-2 to the main form so I can filter and enter data in them?


Thanks.

 

[Uncle Gizmo]

In my blog explaining many to many relationships I also demonstrate how to link a main form and subform together and I also point out some problems that can occur. Regarding your Form's being on a Tab Control, this should make no difference. And regarding the subform that has its own subforms then they should be linked together as described as well. Then the link between child carrying subform and it's main form automatically control what is displayed on the further down subform.

 

[Mark_]

Several questions first;
1) What is the difference between "Friends" and "Coworks"? I.e. are they different tables or the same table but sorted on a given field?
2) Same regarding "Hobbies" and "Activities".
3) Is "Person" the same table as "Friends" and "Coworkers"?

Until you share what tables you are dealing with, it is difficult to describe their relationships.

As important is this an assignment for a class?

 

[DiscombobulatedDuck7]

Thanks for the quick replies, guys. I realized I did a very poor job explaining my problem. Basically, I just wanted to know how you can link a sub-subform to the main form.



However, after some experimenting I think I found a rather simple workaround:
- Make a copy of the main form. Add the sub-subform as a subform. Access will link them automatically if it finds the proper keys.
- Add the copy with the sub-subform to the main form (delete all the duplicate fields on the copy) as a subform and voila, everything is linked up nicely.

 

[jdraw]

See these free, but older videos from DataPig

http://www.datapigtechnologies.com/flashfiles/subforms1.html
http://www.datapigtechnologies.com/flashfiles/subform2.html