Relationship between Main form and Subform

[gsc]

I am relatively new to Access and have produced a database that has a main form with ID (primary key) names and addresses and a subform that shows the Exam reference (primary key) and date with morning and afternoon, yes/no fields, for when someone is available. The probelm is I cannot get the relationship to link the subform with an individual person in the main form. When I click in a date morning field it does this for every record in the main form. I am sure there is a very simple explanation but I am at a loss as to the answer.

[Missinglinq]

You have to have a Field in common between the Table behind the Main Form and the Table behind the Subform. So you need to add a Field to your Subform Table that matches the ID Field in your Main Table. This Field will be a Foreign Key in the Subform Table. Then you select the Subform Control (not the Form but the Subform Control itself) then go to Properties - Data and fill in the names of these Fields in the the Link Master Fields and Link Child Fields. The Form and Subform should now be linked.

Linq ;0)>

[gsc]

You have to have a Field in common between the Table behind the Main Form and the Table behind the Subform. So you need to add a Field to your Subform Table that matches the ID Field in your Main Table. This Field will be a Foreign Key in the Subform Table. Then you select the Subform Control (not the Form but the Subform Control itself) then go to Properties - Data and fill in the names of these Fields in the the Link Master Fields and Link Child Fields. The Form and Subform should now be linked.

Linq ;0)>

Thank you, have done this and it worked but lost the dates from the subform but I think I can work around this so it doesn't matter.