append query

  • Thread starter Thread starter robert
  • Start date Start date
R

robert

I'm attempting an append query, but the key field in the
destination table does not exist in the source table. That
key field is not an autonumber, and can't be, so when the
append is attempted, we get a validation rule error (key
field must have content).

Any way to work around this?
 
robert said:
I'm attempting an append query, but the key field in the
destination table does not exist in the source table. That
key field is not an autonumber, and can't be, so when the
append is attempted, we get a validation rule error (key
field must have content).
Click to expand...

Nope, other than supplying a value in the append query. How does the
target table "normally" get a PK value assigned?
 
Back
Top