Share via

Table Wizard: Step 3a – Set up Relationships

  • Article

If you are creating your table within a database, you can establish relationships between fields in your new table and existing tables in the database.

Highlight the field for which you want to establish a relationship, and then click the Relationships button.

To define a relationship

  1. Click the radio button that identifies the type of relationship you want to establish.

  2. Select the field that relates the tables within the database. If you select <newfield>, type in the field name.

  3. Click OK.

    The Relationships dialog box will close and return you to step 3, where the list displays the new relationship.

See Also

Table Wizard: Step 1 - Select Fields | Table Wizard: Step 1a - Select a Database | Table Wizard: Step 2 - Modify Field Settings | Table Wizard: Step 3 - Index the Table | Table Wizard: Step 4 - Finish | Wizards Overview | Table Wizard