Database Properties for Category to Child and Relationship shapes (Definition)

Use these options to associate columns in the parent and child tables and to enter role names for foreign keys.

Relationships indicate visually how the tables in your database model interact with one another, and editing their properties enables you to control how data is stored and retrieved in the database.

Unknown parent

Lists columns in the parent table.

<--Associate-->

Click to associate the two columns selected in the parent and child lists, creating a relationship.

Unknown child

Lists columns in the child table.

Foreign key role name

For IDEF1X models, type the role name defined by the foreign key relationship.

You can use this name to clarify the business rule that is reflected in this foreign key relationship.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×