relationships between multiple tables

[brans]

I've just started using access and the relationships still confuse me. I'm sure this is very basic, but I can't seem to understand the way they will actually link up.

I am trying to set up a database that has a table for employee information, a table for uniform information, and a table that combines the two, but the combination one has to list all of the uniform item numbers for each employee number.

I'm really not sure how to go about creating the combination table with all the items. I have the employee table and the uniform table. Do I link every uniform item with every employee and create a make table query?

The information I currently have is:

Employeestbl:EmpNum FName LName SSN
Uniformtbl:UniNum Item Price
IUECtbl:EmpNum UniNum Size Qty Rtrn

I need to list all of the uniform items with an option to enter size, quantity, and returned beside each of them for every employee. I want to be able to list this on a form as well showing the employee and all the items.

 

[beckyh]

You need to have a common field between the Employees table and the Uniform table. I would think you would want to use EmpNum. This way you can link the tables using this field.

A good way to get linked tables is to use subforms on your main form, in the beginning when you start data entry. It will automatically create a link between the two tables. Use the subform wizard and it will walk you through the process and help you learn.

You won't need three tables when you create a link between the first two.

Hope this helps.