Relationship created new table?

[khunter]

In the attached db I wanted to create several relationships between tables. After doing this, it created a table_1 table to show the links. Is this normal?

 

[khunter]

I have had problems with the relationships, that was the only way I could get what I needed without too much headache.

A description of the database: An engineer writes an ECR to modify one or more models. This being said; An ECR can have one engineer, one or more ADC (add/delete/change) that affect one or more models.

I have tried many times to construct many to many relationships to no avail. I even posted here for help, none found.

If you need more info on the database function let me know I apprieate the help and would love to create a solid application.

 

[khunter]

After taking a look at the sample many to many you posted I am now even more confused. If I create a fk with Engineerid in ECR
then how can I also have a linked table for models and adc?
I have tried to create this but I can not get any referential integrity with it.

Please take a look at the edited db and point me in the correct direction. As always, thank you so much for the input and your time.

I am really at a loss here as the improper way to design the relationships gives me what I need, but I can not get what I need with the correct design.

 

[khunter]

I now understand how my relationships were pathological, however, I do not understand your new relationship fully. If I can attempt to clarify the logic maybe that would help.

The form should show:
ECR#1 was written by Kirt, it adds partnumber1 and deletes partnumber2 from modelA & modelB. (It should show the add partnumber1 and delete partnumber2, as well as modela & modelb)

ECR#2 was written by David, it changes partnumber3 from modelA. (It should show only the change of modelA)

The form or any variation I have tried with it will not display this info. The relationships do not show it either.

Once again, thank you very much for sharing your extensive knowledge with neophites like myself.