append query

[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?

 

[Rick Brandt]

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).

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