linked table copy records error

[Lost500]

Hi all,
I have a table that i want to copy a chunck of records and then come back in and adjust the ID number. i can copy and paste all the records i want but when i try to change the ID number i get the error

'Single-row update/delete affected more than one row of a linked table. Unique index contains duplicate values.'

the table in question is the the many part to a one-to-many table relationship so that table A (not the table in question) only has one ID number and table B (the table we're talking about) has many duplicates of the same ID number. I already have the ID number i want to use set up in Table A. so i'm lost

any help would be Great.

 

[PHV]

What is the PrimaryKey of Table B ? hopefully not the ForeignKey referencing Table A !

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Lost500]

well there is none. Table B has the ID number duplicated so i can't use that. is there an easy way to set up a unique number field for my table B? there are 6000+ records so i'd hate to key in a number for each record. and do you think that would solve my problem?

the error says 'unique index contains duplicate values'

when i import the linked table into access it asks to select up to somenumber of unique indexes so since there isn't a primary key for table B, I selected three fields that would never have all the same values. one of the fields was the ID number. is that the problem?

 

[PHV]

Why the BE's table doesn't have a PK ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Lost500]

well other than setting up a Unique id number, which i wish i did, everything else needs to be able to have duplicate values. also there isn't a query or form that needs to identify each of these records seperatley. Table A is referenced if there is the need for a unique record.

is there a way to create a unique id field and plug numbers in there for exsiting records? And is this the source of my problem?