Need vba hel - copying rows from one table to another on same database

[ccorley]

Question: What if any is the difference between OrderID and ExpenseID? You use order number in the Me![OrderID] reference, but it isn't in tempLine or Line, so those Insert and Update statements will give you an error.[/QUOTE]


ANSWER: I do not have an OrderID field, only ExpenseID. The order reference I used is Me![ExpenseID]. The field LineExpenseID in the "tempLine" table is linked to ExpenseID field in the "tempExpense" table.

As far as the error in the Line, could I be getting the error because there are more than one row in the "Line" table that is linked to the same ExpenseID? The rows in the Line table are the line items for the order. Wouldn't I have to go through each row in the "tempLine" table and insert them one by one to the "Line" table?

[John_G]

I do not have an OrderID field, only ExpenseID.

Oops - my mistake, and apologies for the confusion.

In the "Line" table, check the indexing on ExpenseID. It has to allow duplicates, because as you say there can be more than one line item for any specific ExpenseID.

To check this, try deleting the index to see if the error disappears. If you still get the error, try deleting all the indexes, run your procedures a few times, then add the indexes back until you find one that fails.