What is not included in referential integrity rules in access

The referential integrity rules in access do not include "query rules". The referential integrity rules in access include "update rules", "delete rules" and "insert rules".

The operating environment of this article: Windows 7 system, access2010 version, Dell G3 computer.

What is not included in the referential integrity rules in access?

The referential integrity rules in access do not include "query rules" .

Referential integrity rules include: Update rules, deletion rules, and insertion rules.

1. Update rules:

Cascading updates can only be enabled for primary key fields set to the "Text" or "Number" data type. You cannot use cascading updates on fields that are set to the "AutoNumber" data type.

2. Deletion rules:

Deleting data from a lookup list requires additional steps. These steps depend on whether the lookup list query obtains its data from the table or from other queries.

3. Insertion rules:

The main table has no keyword value, and insertion into the sub-table is prohibited.

Recommended: "access tutorial"

The above is the detailed content of What is not included in referential integrity rules in access. For more information, please follow other related articles on the PHP Chinese website!