Create table relationships using the auto number field from the master table to the corresponding long integer field in the subordinate table.

Use the relationships screens to relate a master table with a subordinate (detail) table.

Enforce referential integrity in the relationships definition pop up.

Check the ‘Cascade Delete Related Records’ attribute in the relationship setup screen whenever possible. You may not be able to do this when relating lookup tables because the field in the main table can never be blank. Lookup fields are sometimes not filled in at the time of record creation.

When using these table design recommendations, never check the ‘Cascade Update Related Fields’ attribute.

Query Considerations and Tips >