Updating tables with M:N relationships correctly through Forms.

[Guest]

If anybody can help I would greatly appreciate it.

How can I get data inputted through a subform to update my tables correctly
when the tables associated with the form&subform have M:N relationships?

I have built databases before with 1:M relationships and these always easy
to figure out. The M:N challange is giving me headaches and I keep going in
circles.

Basically, I want only the child table to update and not the parent table?

I have tried a join query and many combo box possibilities and every time I
update a child record on the subform it adds a new record to the parent table
rather just adding the child record to the child table.

If you think you can help me but need a better explanation let me know.

Thanks in advance,

Lucas

 

[Jeff Boyce]

Lucas

A many-to-many relationship is resolved with a "junction" table holding
valid combinations of the pieces from the two sides. If this seems a
somewhat obtuse explanation, perhaps you could describe an example of your
data.

I don't understand your situation (I'm not there, I can't see your data),
and am puzzled by your description of updating the child record without a
parent record. How is this related to a many-to-many relationship?

Regards

Jeff Boyce
<Office/Access MVP>