append into source table (1 Viewer)

[Tskutnik]

I'm getting a validation rule violation on an append query. Cant figure it out.

1) Query #1 finds values in the [Sec_ID] field in the [Source] table nut not in the [Enhanced] table.

2) The append pasted those diffs into the [Enhanced] table

The formats for all are Long Integer and the values are whole numbers.

Is the problem that I cannot paste into a table that is part of the Append (and underlying) query? I swear I did something like this before with no problems.

 

[isladogs]

It would help if you said what the validation error was!

It is normal behaviour to append unmatched records to a table in the way you describe.
I'm guessing the you are including the PK field in the Append query and you're getting a key violation due to it being an autonumber field.

If so, remove the PK field from the append & let Access add the PK field automatically

 

[Tskutnik]

So I closed and reopened the db and it worked. Go figure. Thanks