I have a junction table linked to two other tables. This provides a many to many connection.

The two linked tables already have some data, and I can manually put this into the junction table.

But how can I add new data that is entered into one or both of the two tables to be loaded into the junction table in the same record?

Each of the two tables has a primary key that needs to be inserted into the Junction table. Is there a Form setup I can use?

Should I use VBA? How do I ensure each of the two primary keys from the tables get installed into the same Junction table record.

Pictures and/or detailed instructions would help.

Thank you
John Schreiber
[email protected]

I have only set up the junction table with a couple of records for testing. I am just at my wits end trying to figure out how to proceed.