# Enabling foreign key integrity checking

Available in...

* Data Fabric
* MDM Platform

You can enable foreign key integrity checking to manage whether users are allowed to delete a record that is linked to another record through a foreign key. By default, this is not allowed.

## About this task

To enable foreign key integrity checking:

## Procedure

1. In the MDM Repository tree view, expand the Data Model node and double-click the data model for which you want to enable foreign key integrity checking.

   The corresponding editor opens with the selected data model displayed.

   ![](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/fk-integrity-check.png)
2. Select the entity containing the foreign key for which you want to enable integrity checking.
3. In the Properties view, click the Relationship tab.
4. Under the Foreign Key section:
   * Select the Enforce FK integrity check box to enable foreign key integrity checking, that is, to raise an error whenever a user tries to delete a record if the record is linked to any other records through this foreign key.

   * Select the Allow FK integrity override check box to allow users to force the delete of a record even if it is linked to another record through this foreign key.

   These two options can be combined in the following ways.
   |  | Enforce FK integrity enabled | Enforce FK integrity disabled |
   | --- | --- | --- |
   | Allow FK integrity override enabled | Delete allowed, with user prompted for override | Delete allowed |
   | Allow FK integrity override disabled | Delete forbidden | Delete allowed |

   In the case of conflicts, the least tolerant rule is always applied.

   If a user is prevented from deleting a record, details are provided in <$INSTALLDIR>/logs/mdm.log.

### In this section

* [Handling circular dependencies](https://help.qlik.com/talend/en-US/studio-user-guide/7.3/handling-circular-dependencies)