Key Violation Error in Append query

G

Guest

I am running or trying to run an append query and receive a key violation
error. Here is my query..

One example of my QBE

Qry 1
Oblig1 primary key autonumber

qry two
oblig (number data type)

IO also have three tables that are joined together by a product ID number
that all three is a number data type.

I am giving these two queries because I feel this is possibility the hang
up? Can you do a auto number to a number filed in an append query? or a
number to a number to a number field. The above is just the joins. The data
is correct in the select query but when I try a append qry it does not work/
Please help!
 
G

Guest

Which query is giving you the a key violation error?
Yes, if the number field is a long integer.
 

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

Manage append query key violations? 4
Append Query Key Violation 5
key violation on append query 3
Append query key violation 8
query very slow 5
Append Query - key violation - no duplicates, records exist in par 4
key violations in append query: please help 2
Append query - Append to table with Autonumber field 2

Top