Hi.
I'm trying to run an append query to copy from a table to its twin. It works fine the first time I run it, when t_transactions is empty, but fails when it has even a single record and I get a "key violations error" .
I am not including the primary key on the query, and believe it should...