Forms and Subforms

[mykil]

Hi folks!!! Can you help me with this, I want to have a Form for students that has a subform for their respective subject per School Year and Semester...I know how to add a subform in a form but I don't know how relate them...I know, these should have been done through making a relationship with the tables...I want the subject to be unique in every student so that it will avoid duplicate subjects in every student.... I have made an input mask for the StudentID: 00-0-000

Any help will be much appreciated!!!

 

[MStef]

Relate them via "Link Child Fields" and "Link Master Fields" properties,
(Look at attachment, word, zip).
If you want unique record (subform), make a PrimaryKey in the
Subform Table the same as it is in the MainTable, and make a
Relationships.

 

[CBrighton]

Further to above, click on the subform object once to get the properties for the subform object, rather than the form it contains.

The subform object properties hold the link field properties mentioned above.

*This may already be shown in the attachment, I didn't check it*

 

[mykil]

Thanks for the reply! I've just got the answers to my questions in the other post yesterday...Sorry for the late reply