Access forms

[DBneophyte]

Hi,
I have 2 tables in an Access database - Instructor and Course, whose respective Primary Keys are InstructorID and CourseID. Instructor has a one-to-many relationship with Course (InstructorID is the superkey in Course).

I have an Instructor form where the user will enter the instructor's details. The InstructorID is auto-generated on this form. Once the instructor's details are added, the user clicks on Add Course, and a new form opens for the user to add a new course. The Add Course form has an InstructorID field also which is supposed to show the value of the InstructorID previously generated from the Instructor form. I've tried different methods but I can't get the InstructorID field on the Add Course form to populate with anything. So an error is generated because a course can only be added in the table if there is a corresponding instructor. Please help. I can manually add the data in the tables so i know the tables are linked correctly. Thanks

 

[PHV]

Provided the RelationShips are properly set, simply follow the subform wizard.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886