Key Violation

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Back
Top