Key Violation Errors using Update Query

B

Billy

I have 2 Tables. Table1 has PartNumber and PartID. However, PartID
is currently empty. Table2 has PartNumber and PartID (PartID is
autonumber and is the primary key). In the Update Query, I have
Joined the Tables using "Only include rows where the joined fields
from both fields are equal."

Since I am updating Table1 where the primary key is StockID, why am I
getting KeyViolations by using Table2.PartID as part of the update?
It seems like it wouldn't matter if Table2 primary key is PartID since
I am not updating that table, only using the data inside it.
 

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

Append Crosstab Query to Existing Table 0
Tricky (challenging?) sub-report problem 1
Changing Relationship from 1-to-1 to 1-to-Many 5
Using <= in countifs statement 1
Looping and Duplicating Records Access 2007 6
primary key - concatenated or autonumber? 6
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Query from expression 2

Top