Correcting Table Structure

Hello,



I have been working on a a table design, but I am failing to create the correct relationships.



My main table is the tblIncident with the three remaining tables being linked via a one to many relationship. I am using an auto number as my primary key, then linking that number to a FK in each table.



I am not doing something correct, but not sure what it is. The end goal is to create one form with a varying sample of combo boxes, check boxes and data entry fields from each table.



I did not plan to create a subform for each table, but maybe that is required?



I have attached my sample database in hopes of explaining it better.



Thanks for any help.



Brent

Attached Files

IDCO.accdb (484.0 KB)

Correcting Table Structure