answersLogoWhite

0

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

User Avatar

Wiki User

17y ago

What else can I help you with?

Related Questions

What are the two methods of designing a table in MS Access?

Use the table wizard or design view.


An element found in table salt is?

There are two main elements found in table salt. Sodium and Chlorine. Its formula is NaCl


What can use two different views to create a table?

In a database management system, you can use two different views to create a table by performing a union operation on the two views. This will combine the results of the two views into a single virtual table, allowing you to access the data from both views in one unified table.


IEEE has divided the Transport layer into two sublayers?

No. It is the Data Link layer that IEEE has divided into two sublayers. The Data Link layers are Logical Link Control and Media Access Control.


Name two ways a router can limit internet access?

Linksys, D-Link


What is a link between two or more things a plane or line?

a link between two or more things; a plane or line


A data table depicts the relationship between two or more?

between two or more varibles


How do you add text files to a MS Access database?

There are two methods to add a text file to a MS access Database.1) Link the text file. Go to File/Get External Data/ Link Tables. In the link file screen change the file type to Text file and then browse to the text file and select your text file. MS Access will prompt you to give the specs of the file when you are linking it. 2) Import the file to an access table. Go To File/Get external Data/ Import. In the screen change the file type at the bottom to text, and select your text file.


How many table views are available in MS Access?

There are two main view Datasheet View AND Desing View OTHER'S Pivot Table View Pivot Chart View


What is the difference between one way and two way table of specifications?

First off, a table of specifications also known as TOS is crucial in the content for validity of tests because it shows the one who gave the test and the candidate on the same screen. The difference between one and two way table of specifications is a two way table is great to access a persons quality of learning.


In Tennessee do you have to let the child go if non costodial parent is behide on child support?

Yes, because of the two, denial of access is far more damaging to the child, and to society in general. see link


What two methods can be used to provide secure management access to a Cisco switch?

You can configure addresses manually or configure the switch to learn the addresses dynamically. For more detailed information visit the Related Link.