Assigning Table Relationships Using the Table Wizard

Assigning Table Relationships Using the Table Wizard

When you create a table using the Table Wizard, you have the option to relate the new table to the other tables in the database. The Table Wizard displays a list of established tables. You can choose to create a relationship between the new table and any of the tables in the list. You can create relationships between the tables in which a record in one table matches with many in another. When you create a one-to-many relationship, the Table Wizard automatically adds new fields to the related table if necessary.

Create a Relationship Between Tables

graphics/1_icon.jpg

When the Table Wizard displays the dialog box listing related and unrelated tables, select the table whose relationship you want to change, and then click the Relationships button.

graphics/2_icon.jpg

Click one of the three options describing the relationship between the new table and the established table.

graphics/3_icon.jpg

Click OK.

graphics/03inf06.jpg

See Also

See "Defining Table Relationships" on page 60 for information about establishing table relationships.


Relationship Options

Option

Description

The Tables Aren't Related

No relationship will exist between the new table and the established table.

One Record In The New Table Will Match Many Records In The Old Table

Create a one-to-many relationship. Access sets the new table as the primary table and the established table as the related table.

One Record In The Old Table Will Match Many Records In The New Table

Create a one-to-many relationship. Access sets the new table as the related table and the established table as the primary table.




Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net