How do you link two or more access table?

Answer 1

Creating Relationships between Tables Relationship is an association established between common fields (columns) in two tables. A relationship can be one-to-one, one-to-many, or many-to-many. When you create a relationship between tables, the related fields don't have to have the same names. However, related fields must have the same data type unless the primary key field is an AutoNumber field. You can match an AutoNumber field with a Number field only if the FieldSize property of both of the matching fields is the same. For example, you can match an AutoNumber field and a Number field if the FieldSize property of both fields is Long Integer. Even when both matching fields are Number fields, they must have the same FieldSize property setting. Opening the Relationship window 1. Click Tools Menu

2. Click Relationships

3. Select the table from the Show Tables dialog box

4. Click Add to Add the tables

5. Click Close button Note: To open the Show Table dialog box

Click Relationship Menu

Click Show Tables To create a New Relationship 1. Click Relationship Menu

2. Click Edit Relationship

3. Click Create New button

4. Click Left Table Name arrow & Select the table

5. Click Right Table Name arrow & Select the table

6. Click Left Column Name arrow & Select the field name

7. Click Left Column Name arrow & Select the field name

8. Click OK button

9. Click Create button For more details refer http://msaccess.batcave.net