Subform does not update table

[pivottable]

Hi,

I have a many to many relationship between tblMain and tblComp, where the junction table is jtblMain_Comp. The real life scenario is one person can have many complications, and each complication can be encountered by many people.

I've set up a form with a subform, to enter multiple Comp. I thought that by defining the relationship, the MainID would be entered into the junction table whenever a Comp is entered, but I'm clearly missing a step.

Sample database attached.

Thanks!

 

[JHB]

.. but I'm clearly missing a step.

2 steps to be completely accurate:

1. Include the ID field in the query for the main form.
2. Link the main and subform togehter using the "Link Master Fields" and "Link Child Fields".

Database attached.

 

[pivottable]

That's great!

Thanks!

 

[JHB]

You're welcome.