In MS Access, how do you create one to many relationships and one to one relationships?

Answer 1

There's a relationship wizard...the button looks like 3 little boxes joined by lines. Open it and add the tables you want. Drag ID (for example) from table1 to table2 and a link appears. It will ask if you want one to one..one to many...etc

Answer 2

Try this link:
http://support.microsoft.com/kb/304467/en-us

it is called Defining Relationships Between Tables in a Microsoft Access Database

Answer 3

Suppose you have Table_A and Table_B.
Define a unique ID field in Table_A, Table_A_ID.
Define a unique ID field in Table_B, Table_A_ID.

To create a one-to-many relationship between Table_A and Table_B, add a Table_A_ID field in Table_B. For each item on the many side of the relationship, you set the Table_A_ID field to the Table_A_ID value of the corresponding record on the "one" side.

To create a one-to-one relationship, add a Table_B_ID field to the Table_A record and set its value to the ID of the corresponding Table_B item.

You didn't mention many to many relationships. To do those, you need to add a new table to your database. The fields would be Table_A_ID and Table_B_ID. For each pair of items that are in the relationship you would add a record to the relationship table.