Many-to-many - Joint table and form

[mike60smart]

I cannot for the life of me see how your solution is an improvement on a standard Many to Many.

If you want to go this route then do carry on.

 

[Jimis]

I was not looking to improve any standard.
I was trying to make something easy for the user to handle in a productive manner.
Now he doesn't need to open a form select the right combination of Customer and customerERP remember the ID and input that in mainform. It's all done automatically.

 

[Pat Hartman]

It's all done automatically.

As it is in the sample I posted. No one has to remember any IDs. The relationship is made using a combo.