Found a solution at last.

I save the ID of the OrderItems in the temporary table. When cancelling I delete all OrderItems, insert the old ones from the temporary table. Then i run a dlookup(max([ID]) on orderitems table to see the new ID of the last order item, do the same on the ID's in the temporary table. Now I subtract the old one from the new one, and then when adding the additions i add the result to the OrderItem reference so...

Hello,

I have a form that edits an Order. Each order has several OrderItems which are edited by a continous-form subform inside the main form. Each OrderItem also has several OrderItemsAddit ions which are edited from a pop-up form.
3 seperate tables:Orders,O rderItems,Order ItemsAdditions.

The big problem is that i need a way to undo all changes to an order. When clicking on the "Edit" button (data is...