Query->db changes

[Guest]

I have a table (I)containing some columns with link to other tables(a,b,c,d).
Filling in this table, I get a combo choose box to insert values from a,b,c,d
in the (I)-table.

Now I have a query that shows just one of the records in (I). When manually
changing column values of (a,b,c,d) links I get this error:

ERROR <The changes you requested to the table were not succesful 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 define the index to permit duplicate entries and try
again.>

I want to be able to change values in query so that this record is adjusted
in the (I) table...

Please push me in the right direction...

Thx

 

[JohnFol]

Are fields a,b,c,d used to make up the PK?

 

[Guest]

John,
yes, they were primary key.

In my query design, I linked my tables the same as I did when defining the
relationships. Apparently I shouldn have done that, when deleting these
'lines' , the problem is solved.
Yhx