Auto Populate Foreign key fail

[ChunkyChats]

Hi Guys,

I'm trying to create an investigation form template in Access which has multiple sections in order to classify both causal factors and contributory factors. For some reason I cannot get the primary key to auto-populate the foreign key in each of the sub sections. I've attached an abbreviated example of what I'm trying to achieve. this should show how I've set up the relationships between two tables.

essentially I will be setting up a table for each section of which there are about 15 sections. Each report is unique and I will generate a report to print it off when complete.

I will also and this is the key part be doing quite a bit of data analysis on the findings.

Any help gratefully received.

Steve

 

[Gasman]

You have not set the link fields in the subform.?

However when I try it states 'Can't build a link between unbound forms'?

I created the forms from the tables and that works fine.

DB attached

 

[ChunkyChats]

That's great many thanks. I had the same problem with the unbound warning, not sure what I did there. When creating the frmsectionGenInfo1 form did you manually add the subform or use the create form button and it auto created the link in the tables? for future reference.

Again many thanks for your help.

Steve

 

[Gasman]

I just dragged the form onto the main form from the list of forms on the left.