Design correctly related forms

[Kayleigh]

Hi,
I'm working on a set of forms which follow on one to the next. The first form inputs the basic student information, the second form involves the guardian data. However I am having trouble with the second form - since it must be linked through a junction table. So when I open the second form the form always comes up with an error. Can anyone help resolve this?
Also the drop-down list of existing guardians not working - possibly related to above issue.
Thank you

 

[June7]

Suggest you explore using form/subform arrangement. Main form bound to tblGuardian, subform bound to jtblStudentGuardians with combobox to select student. Use combobox NotInList event to add students 'on the fly' during data entry. All common topics.

Or go the other way around with main form bound to tblStudents, subform bound to jtblStudentGuardians with combobox to select guardian.