Hello all,
I have a main table (students) with students basic information (eg name, Date of birth, address, contact number) and have made a form. The primary key is StudentID.
StudentID (PK)
Name
DOB
Address
Contact Number
I have created another table (demographics) where I want to hold the student’s demographic details
DemographicID (PK)
StudentID
Gender
Ethnicity
I have linked these tables in ‘relationships’ (with ‘enforce referential integrity’, ‘cascade update related fields’, ‘cascade delete related fields’, all ticked) on StudentID.
I have then made a form from the students table and another form from the demographics table. I would like to open the student form and input details then click on a button to open the demographics form and fill in the demographic details for that student. How do I get the StudentID to be passed when I open the demographics form so that I’m adding this data to the correct student?
Could anyone help please? I suspect this is easy but I'm struggling.
Thankyou