Foreign Keys

Create a foreign key by drawing a foreign key link between two tables on your database diagram or from the Foreign Key tab of the child table's property page.

How do I open an object's Property Page?

Tell me more about foreign keys?

If the child table has column(s) that match the primary key column(s) of the parent table, Visual Case will set up the join automatically.  If not, you must specify the columns.

The foreign key property page also allows you to specify the cardinality of the join and, if you're designing a Microsoft Access database, whether you want the database to do cascade deletes.  When the cascade delete option is selected, the database will automatically delete matching records in the child table when a record is deleted from the parent table.

Related Topics:

• Database Basics - Foreign Keys

• General Table Properties

• Columns

• Indexes

• Constraints

• Triggers

• Database Basics

• Database Tools