Hi Richard,
  I'm creating a staff training database and have 3 main tables
tbl_Employees (Personal Info)
tbl_Training(Job training details)
tbl_Jobs(List of different jobs)
  My tbl_Training will be populated via a form which will be used to fill in a persons job skills. I need to add two subforms to the main form which list Equipment Items and Protective Clothing issued (these will be stored in 2 separate tables. I can't seem to get the relationships right for this set-up. Could you give me any advice ?

Thanks a lot,
Paula

---

Reply from Richard Rost:

Sure. I cover relationships in Access 201. You will need to have an EmployeeID as a FOREIGN KEY in your Equipment and Clothing tables. That's what relates each record back to your Employee. Now, set up 2 subforms (Access 202) on your Employee form (using the Wizard here is OK) and relate them using that EmployeeID field.