error when trying to add a second record to subform

[dannydm]

Hi guys,

i have a form which has a sub-form on it. each one is bound to a different table. the main form has a one to many relationship with the subform, but every time i try to add a new record to the subform i get an error say that you cant insert a duplicate foreign key.

not sure how to solve that as sql enterprise manager and access do seem to have the option to allow duplicates on the foreign key coloum.

 

[RuralGuy]

Have you checked that fields specifications in the table to see if it is set to indexed w/no duplicates?

 

[dannydm]

how do i do that? cant find any option for indexing with no duplicates....

 

[RuralGuy]

Is this table in Access or SQL Server?