Easy 2 table Query question

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

Guest

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!
 
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.
 
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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Could the foreign key prevent.. 3
Update Query Error "Key Violations" 14
Using Append Queries with Linked Tables 3
Non-updateable query issue 24
How to UPDATE a field in a joined table? 8
append query 1
Cascade Update using only queries 6
Key violations on Append query - no indexes on table 8

Back
Top