Form With subform problem

[banpreet]

I have a form with 3 subforms, each subform linked to different tables. The Parent Id on the main form is TR_ID, and I made the same field on each subform so I can link up the parent and child Id. Now these three subforms are tables on the form, so everytime I put a new record in the table, I get a message saying that is duplicated. The first record in the subform is fine, but just the second record I get the error that its duplicated and can not be put in, I want each record in the table to be the same TR_ID, but that's its not working. All help is appreciated!

[John_G]

It's because the table(s) in the subform(s) have a unique index on TR_ID. Did you make TR_ID the PK of the subform tables? If so, take it off and add a new PK for the sub-form tables. An autonumber field would do, and you don't need to show it on the subforms.

[banpreet]

Thanks worked perfectly!