I have a database with three tables: 1) employee demographics with EmployeeID 2) employee specialties with SpecialtyID and 3) EmployeeID & Specialty ID. My tables are fine and the main query I run off them for searches is fine. All data is linking up as it should based on the relationships I have set. Now, data entry is another problem. I have a form where I can enter staff demographics easily enough using text boxes. However, I am having trouble entering the specialties for employees, which uses a combo box and list of specialties. I tried using a form based on the EmployeeID & SpecialtyID table with two subforms for the Demographics, linked to the main form, and Specialties, unlinked to anything, and it half works. The employee demographics come over but the specialty IDs are not linking and as such not showing correctly in the table. Should/Can I link the 2nd subform to the main form and if so, how? Thanks in advance!
I have information from all three tables in the query. The first table (tblEmployees) is linked to the second table (tblEmployeesSpecialties) by the field EmplID which appears in both. The third table (tblSpecialties) is linked to the second table (tblEmployeesSpecialties) by the field SpecID which appears in both tables.
I'm attaching the database if you need further info. Thanks in advance for the help!