I have table A and table B with a many-to-many relationship. I have table C as a junction table.
I have a form that browses through table A with a subform that shows a summary of the related items from table B. If I double click any of the items in the summary subform, I get another form that allows me to edit all the items in table B. The relationships and the junction table are working fine.
My problem is this: I have to initially create the items for table B by filling in a new summary line on the subform. Apparently Access is updating the junction table for me. That's nice.
But what I really want is to have a button labeled "add" that will cut out the middle man and just pop up a blank form for creating a table B row. I can do that of course, and the row is created in table B, BUT THE JUNCTION TABLE IS NOT UPDATED.
How do I update the junction table in this scenario??
(sorry for the long description :-)
Thanks for your help!