H
hughess7
Hi all
This is driving me mad - am I going potty? ;-). I have a load of old records
in a table called [preECS] that I want to add to another table. I have
created an append query but it won't append the records as it says it would
create duplicate values. The key on the new table is Specialist and
ReviewDate - both of these are filled out in the preECS table and I have
checked the dates to ensure no data does actually exist. It should not create
a duplicate record and I am confused why I can't add these records :-(. The
new table has an autonumber which I've excluded from the append query, but
this should just generate a new unique number I think? I have removed all
other keys to make sure I'm not missing any required data or anything but I
just can't seem to get this to work. I have re-linked tables and compacted
and repaired etc... any ideas?
Thanks in advance for any help.
This is driving me mad - am I going potty? ;-). I have a load of old records
in a table called [preECS] that I want to add to another table. I have
created an append query but it won't append the records as it says it would
create duplicate values. The key on the new table is Specialist and
ReviewDate - both of these are filled out in the preECS table and I have
checked the dates to ensure no data does actually exist. It should not create
a duplicate record and I am confused why I can't add these records :-(. The
new table has an autonumber which I've excluded from the append query, but
this should just generate a new unique number I think? I have removed all
other keys to make sure I'm not missing any required data or anything but I
just can't seem to get this to work. I have re-linked tables and compacted
and repaired etc... any ideas?
Thanks in advance for any help.