Connector Xpress Guide › Troubleshooting Connector Xpress › Multiple Foreign Key Constraints

Multiple Foreign Key Constraints

If the database table mapped to accounts is associated with multiple foreign-key constraints, do either of the following:

• Write a stored procedure to delete the account and the associations the account has with other tables.
• Configure a cascading delete in the database schema.

For example, in a company inventory database, the foreign keys in the customer group table and customer order table reference a customer account table. Customer account is mapped to account and customer group is mapped to account group in Connector Xpress. When you delete an account, Connector Xpress automatically deletes any entries in the account group that relate to this account. However, Connector Xpress does not delete the customer order table. The delete operation fails because of a violation of the foreign-key constraint.

To resolve the problem, do either of the following:

• Write a stored procedure that removes any entries that are associated with the account that you want to delete before the actual account is deleted.
• Configure a cascading delete on the customer account, if the database vendor or schema supports this feature.