Table Wizard: Step 3a – Set up Relationships

See Also

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.