Im creating a database where there are three tables (call them table1, table2 and table3) which have most of the same fields in all of them. I have created two append (call them append1 and append2) and two delete queries (call them delete1 and delete2).
Now when i want to transfer records from table1 to table2 via a form, i press a button on this form and it transfers the records from table1 to table2 using append1 and then deletes the records from table1 using delete1. This works perfectly.
The problem is that i cant seem to transfer the records from table2 to table3 using append2 and it does not delete using delete2. I have checked everything i possibly can from the data format to going through the VBA code where i have embedded the sql statements. Keep in mind that append1 and append2 use the same data to transfer, the same applies to delete1 and delete2.
Any help would be greatly appreciated, Thank You.