Relationship btw form and subform

[dr223]

Hi,

I have a main form (stud_details) also I have a subform called (pay_det_sub).The subform is displayed on the main form.
I want to create a relationship between the stud_details and pay_det_sub, with the aid of a field on the stud_details called numhus (which is the primary key).

So that when a student with a specific numhus value is displayed it brings about the payers details on the subform.

What's the best way of doing it??? Is it necessary to have numhus value stored also in the subform table to create a relationship....

Thanks

 

[Uncle Gizmo]

you should be able to access the properties of the subform window and defined the common field between the main form and the subform there.

 

[dr223]

Please could you elaborate more, as it is not clear to me yet!!!

Thanks

 

[Moniker]

In the subform, set the MasterLink property to numhus, and set the ChildLink property to numhus. That should have one update with the other.