I am using MS CRM 4 and have created two custom entities (supplier and Items) each supplier can have many items assigned to it. I have further created a 1:n relationship to facilitate this.
The problem is when a user mistakenly assignes a wrong item(s) to a supplier and then decides to delete it/them he ends up deleting the item(s) in a cascade manner. Hence rather than a link between supplier and item(s) being removed the item itself is deleted
form the Items list along with all other suppliers item is associated with,
I have set the relationship behaviour of 1:n to Referential where delete is set to 'remove link' but this does not work as expected.
Can you please advise how I can set-up the entities to remove the link rather then delete the item.