I am editing an existing databse to make it more user friendly and have run into a snag. Here is my table layout:
Prefix (Part of composite PK) Text
Number (Part of compoite PK) Text
UserID PK Autonumber
SessionID PK Autonumber
UserID FK to tblUsers
CourseID FK to tblCourses
I am tring to create a form and subform for users to sign-in and complete training. It doesn't supply the training, it only prints a list of training to be completed and user information.
The main form it for user information and is based on a parameter query that requests the users employee number on form open. If they have used the system before then their information shows in the form, if not they type in the information and are loaded for the next time. This part works right now.
I can't figure out how to get the subform to work, it needs to allow a user to select courses from tblCourses and put that ID in tblSession. One user may take more than one course in each session. I think I may need another table to make this work but I am not sure. Please help!