Suppose that you have objects Account and Company. They are peers. Account.Company is a 1 to 1 reference with matching attribute Company.Accounts, which is a many to 1.
If I find and delete a Company that has a reference to an Account, will it automatically be removed from the Account.Company attribute's value?
If I delete the Account , will it automatically be removed from the Company.Account's attribute's value?
I think the answer to those two questions is yes, but I'd like to know for sure.
Now, if Account and Contact are peers and Account.Contacts is a 1 to many reference to a Contact with matching attribute Contact.Accounts which is likewise 1 to many, if Account is deleted is it automatically removed from Contact.Accounts?
And if the Contact is deleted, is it automatically removed from Account.Contacts?
Again, I think so.
But, Account also has reference Account.MainContact, a peer 1 to 1 relation to a Contact, without a matching attribute in Contact. When a Contact is added to Account.MainContact it is also added to Account.Contacts.
When I delete a Contact that is currently in an Account do I first have to find and remove it from Account.MainContact before I delete the Contact?
If I don't do that what is the consequence? What will be visible, or what eror message will I get?
thanks,
Terry