One-to-many join destroys existing links
One-to-many join destroys existing links
One-To-Many joins destroys existing links and recreates them. I want to keep existing links as they already contain additional information. Example: On an order, I select my products (Checkboxes) I need. Then, on order details, I select the the quantities. When I go back to the the order to include another product, the existing order details are replaced and quantities
missing.
This discussion has been closed.
Answers
I'm sorry to say that there isn't any option to keep the existing rows with the PHP and .NET libraries for Editor when doing an Mjoin with a link table. They will always destroy and then create the new rows, rather than attempting to do some kind of diff between the rows. For that reason, link tables used by Mjoin in Editor should not contain any meta data since it will be lost when the data is written to the database.
Sorry I don't have better news for this one!
If the link table had an id of its own, then it would be possible for the libraries to be modified and retain that information - but most link tables are simply two foreign key references.
Allan