SUBFORM ?

[billmush]

I created a database form with subform the subform record I have being controlled by the main form. It was working fine until recently.
now I get a message anytime I try to enter information in subform

the changes you made to the table were not successfull because they would create duplicate values in the index, Primary key, or Relationship. Change data in the field or fields that contain duplicate data, remove the index, or redefine index to allow dupicate entrys and try again.

the relationship between the two forms is the serial # field. which is not displayed by the subform (Hidden) I feel I'm overlooking something in the properties of the subform, table of the subform or the Query. I'm not sure

any help would be great or even pointing me in the right direction.

thanks in advance

 

[billmush]

In the index property of the ID on the Subform Table needed to be changed to YES (allowDuplicate Records) and no primary key selected.

This fixed the problem