Create and modify relationships??

A

AllieCoco

Does anyone know how to create and modify one-to-many relationships?
Thank you.
 
K

Klatuu

From the main Access menu, Tools, Relationships.
Right click to get a menu and select Show Table.
Select the tables you want to include in the relationships.
Click on the field in the table you want to be the one side of the
relationship.
Drag to the field in the table you want to be the many side of the
relationship.
Fill in the options on the dialog box that will pop up.
 
Top