Easy 2 table Query question

T

troy

I have two tables. One target and one source. Both have a primary key called
productID. The source table also has ANOTHER Primary key which makes it
foreign key. I am trying to update a few fields from my source table into my
target with an update query and I am getting Key violations. What is the best
work around without touching the properties. Thank you and yes I know I have
to chged properties but I cant and the compay will not let me. What other
options do I have? Please help!
 
K

KARL DEWEY

A table can only have ONE primary key. A table can have a compound primary
key consisting of two or more fields to form a unique data combination.
 
T

troy

Then why am I getting a key violation when neither keys are beign used in y
update query. I have checked and doubled checked every possible option?
 
K

KARL DEWEY

If you are adding to the one side of a one-to-many relation and the data in
the key field is a duplicate in the record being added you will have a key
violation.
If you are adding to the many side of a one-to-many relation and there is no
matching data in the one side of the relation then you will get a key
violation.
 
Top