What will happen if i change the existing relationship from

Hi Sudhakar,

Changing the relationship to Many Secondary to One Warehouse will not cause data loss, records will just be detached to original records BUT when doing the action below.

If you are going to create new records from Warehouse and select the existing secondary records with Warehouse attached, it will be detached to the original parent and will be transferred to the new record.

Suggestion:
1. Don't add the lookup of Secondary to New/Edit warehouse page to avoid detaching existing records.
2. If you want to add the lookup of Secondary to New/Edit Warehouse make sure the lookup list view is not showing those Secondary with already warehouse record attached.
3. It is safe to have lookup of Warehouse in the New/Edit page of Secondary.

Hope this may help.

Regards,
Orchid

thanks [mention:e6fb884e9c7b45a2a638966c06dc0941:e9ed411860ed4f2ba0265705b8793d05]