Working with Many to Many Relationships in Forms and SubForms

[Bkper087]

I guess this is more of a general design question. With a many to many relationship using a junction table, do I have to manually plug in the ID numbers from the related tables in the junction table for it to recognize the related data? It sounds silly and obvious I guess that you would have to, but when I go to create a form based on a many to many relationship, I would like the ability to enter data without having to enter the related ID numbers in multiple places on the form or subforms to make it work. I guess I envisioned access using auto numbers to automatically update the junction when I wanted to add data related between the "main" table and the distant table joined with a junction. Can this be fixed using a Parent/Child relationship set-up in some fashion or am I just wishfully thinking?

[pbaldy]

Not clear on what you've tried. I'd probably use a form based on one of the tables with a subform based on the junction table. Master/child links would automatically add the ID from the main form's table. I'd have a combo to select the ID from from the other table.