Richard,
I have been watching your Access Classes for the last few months.  I have been messing with Access for 15 years and have always hardwired my relationships between tables, watching your classes I learned that you can relate tables using queries only, and I see the importance of Primary Key and Foreign Key.
I have a form with a Tab Pages. The main table is GuestT there are other tables like EmploymentT and MedicalT.   I have built child sub forms, MedicalChildF and EmploymentChildF. I also built a query MedicalQ  that uses the GuestT and MedicalT.

I inserted the MedicalChildF into the tab page “Medical Info” it works great all the information is keep in the right relationship. The MedicalChildF gets its data from the MedicalQ.

I then inserted the EmploymentChildF into the tab page “Employment Info” it too works great all the information is keep in the right relationship.  I did not build a query for EmploymentChildF.

Yes the wizard did ask me to show all records in EmploymentT that matched GuestT where GuestID = GuestID.

SO HERE IS MY QUESTION! Where is the code that makes the relationship in the form and subform without a query?  I have looked at the properties for the child form and the “Record Source” is “EmploymentT”  and if I click on the “…” a screen pops up Saying “You invoked the Query Builder on a Table.  Do you want to create a query based on the table?”  So I am ASSUMING there is no query here. So just how are the forms related to each other.

You help in helping me understand is greatly appreciated.  Gary Morrison

P.S. I am using Access 2007

---

Reply from Richard Rost:

Open up the properties for the child subform - not the FORM properties inside the subform, but the actual properties for the SUBFORM CONTROL (the selection type on the property window will say: subform/subreport).

You'll find two properties: Link Master Fields and Link Child Fields. Just put the field names in these properties that link your two forms together. In your case, they're probably both GuestID.