Problems of deletion of many to many relationship object

0
Hello,   I have these scenarios.  I just masked them into Order and Items and Items and Order are in a many to many relationship   Order#1     Item#1     Item#2   Order#2    Item#1    Item#3   But whenever I would like to delete the association Item#1 on Order#1 through a microflow after being deleted in the UI, the association of Item#1 in Order#2 also be deleted :(  Only the Item#1 of Order#1 should only be deleted   This is the removal of the association that I used.   What should I do? Thanks!
asked
1 answers
0

Hi John,

 

It is better to use an OrderLine entity, so per order you get an object which relates the Order and the Item and can keep track of things like how many items (for that item on that order), the current price, when it was added, by who, notes for that specific order/item combo.

 

[Order] <---1-n---[OrderLine] ---n-1---> [Item]

 

With kind regards,

Stephan

 

 

answered