Hi everyone,
For my database, I have a append query which takes all the rows from Temp_Table (except the primary key field) and appends it to the main table (Task_Detail_Table).
What I discover is that it does not add the rows as new records to the main table but overwrites existing rows instead.
What did I do wrong and how can I fix it? I want to add the rows from Temp_Table to the main table and I expect the primary key to be auto-generated for the newly added rows.
Attached is the database stripped of all the tables, forms, queries and reports which are not relevant to the issue (for sensitivity reasons).
The query in question is intQuery_to_append_from_Temp_to_Task_Detail_Table_for_Others_TR.
Thanks in advance.
For my database, I have a append query which takes all the rows from Temp_Table (except the primary key field) and appends it to the main table (Task_Detail_Table).
What I discover is that it does not add the rows as new records to the main table but overwrites existing rows instead.
What did I do wrong and how can I fix it? I want to add the rows from Temp_Table to the main table and I expect the primary key to be auto-generated for the newly added rows.
Attached is the database stripped of all the tables, forms, queries and reports which are not relevant to the issue (for sensitivity reasons).
The query in question is intQuery_to_append_from_Temp_to_Task_Detail_Table_for_Others_TR.
Thanks in advance.