Georgina has attended:
Access Introduction course
Access
How do you link a primary key to a foreign key
RE: Access
Hello Georgina
Thank you for your question; and welcome to the forum.
You can use the Relationship Window in Access to link tables together. This can be done by clicking on top of the field you wish to link to another, then dragging to the field in another table you wish to link to.
You may find the following tutorial on the Microsoft web site useful, as it covers table design and types of relationships that can be created between tables in Access:
http://office.microsoft.com/training/Training.aspx?AssetID=RC061183261033& ;CTT=6&Origin=RC061183261033
Amanda