Key Violation

[Guest]

Hi I'm trying to merge two tables.

The table receiving data has a primary key field. A sql statement will only
merge data to the fields that are empty in the same record. This works ok.

UNLESS - the table supplying the data has two records with the same data in
the key field and the table receiving the data DOES NOT have a matching
record.

if the table receiving the data HAS a matching record, all is sweet.

How can I fix this ????

Thanks for your time,

Ross.

 

[Jeff Boyce]

Ross

?Only run your Append on records that meet your criteria? Use a query to
get these.

?Index the receiving table so that it only accepts the first of the new
records?

Got a simplified example?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/