Merge error

Former Member
Former Member $organization

Hi
I have a number of merges that are failing because the "DELTETE statement conflicted with REFERENCE constraint "FK_T_AFFILIATION_TX_CUST_SAL_salutation_no."
Any ideas how to fix this?
Thanks
Jess Levy
SFMOMA
415-357-4108

Parents
  • Unknown said:

    I have a number of merges that are failing because the "DELTETE statement conflicted with REFERENCE constraint "FK_T_AFFILIATION_TX_CUST_SAL_salutation_no."
    Any ideas how to fix this?

    Sounds like it doesn't like something in the Salutation field of an Affiliation, i.e. it's pointing to a record that doesn't exist in TX_CUST_SAL. Clear or correct that, and you should be OK.

Reply
  • Unknown said:

    I have a number of merges that are failing because the "DELTETE statement conflicted with REFERENCE constraint "FK_T_AFFILIATION_TX_CUST_SAL_salutation_no."
    Any ideas how to fix this?

    Sounds like it doesn't like something in the Salutation field of an Affiliation, i.e. it's pointing to a record that doesn't exist in TX_CUST_SAL. Clear or correct that, and you should be OK.

Children
No Data