Urgent - I'm reposting this here. Please help!

[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!

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.

 

[John W. Vinson]

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.

Please post the SQL view of the mainform and subform's Recordsource, and the
Master/Child Link Fields.

It's not as hard as you're making it! A two-field primary key is a bit more
hassle, but can be made to work. Note that the Master and Child Link Fields
can contain two fieldnames separated by a semicolon.