Explanation of Master/Subform and PK/FK Link fields
Posted on 2004-09-02
I need an explanation of how Master/Subform works and how to link the forms.
I have 2 tables. They are related by orderid. Orderid is 1 to many from Main to Multiplelinetable.
Main = orderid
Multipleline = orderid.
When I create a Main form and add Multiple Line as a subform, when I add a new record to Main, and then a new record to multipleline, the orderid is not being put into the multipleline table. Hence, they are not linked.
I read about PK/FK and Master and Child fields, and it seems that the child field should be automatically populated but I have no idea what I am doing wrong. Please explain how it works.