Hi All:
I am creating a database for my organization to keep track of members, but I must admit I'm a bit rusty with Access, not that I was terribly skilled to begin with. I have numerous many-to-many relationships where a table and a static list are joined with an association table. All of the association tables contain a PK and two FKs from each related table. All of the FKs have related select queries linked to the tables containing static lists.
We are hiring two data entry clerks on short-term contracts at the end of the month to process all our membership registration forms, so I am trying to create a form with a tab control subform to help them. Everything works fine, except when I enter data for any of the association tables. I have the lists accessible via list boxes on tabs with extended multi-entry enabled. When I do test runs none of the association tables fill in. Right now I only have two sub-forms on the main form (form START HERE) experiencing this problem (both in the "Type/Sector" tab, although I tried one with the same results in the "Crosscutting" tab.
I attached some screenshots for reference (the database was too large to upload).
Best,
Josh