Help! Need to Enter data!

[WestWingFan]

Ok, I have a crazy question, but surely someone has an answer. I have five
tables I would like to enter information into what looks like one form (I
know it will have a series of subforms). I can't seem to get it to work. My
tables (simplified) are: Title, Section, Item, Statement, Clarification. All
the relationships are one to many down the chain - except for the Item table
whose PK is a combo of SectionID and StatementID. It would seem to me that I
should set tblItem as the parent recordsource, but then I would need a
subform for Title (with a subform for section) and I cannot link through the
subform - or can I? I hope this is clear! Thanks in advance for any help!

 

[WestWingFan]

More information. I have changed the PK to a new autonumber PK for tblItem.
This seems to help. I am still having trouble getting the sbfrmStatement to
work properly. If I link it to sbfrmItem, then I cannot add new records. If I
leave it unbound, I don't know how to write the StatementID to the correct
field in tblItem. I'm new to coding, please be kind.

 

[WestWingFan]

Never mind.... it's amazing what you can do with the not in list event....