Undo Record save

[mshirwan]

Hi all I have an order form similar to the one of Nothwind sample db, the problem that i have is when data entered to the form there is not way of undoing the data since there is two subforms that store data in different linked table, any ideas?

I am still waiting for an idea.

 

[Pat Hartman]

Once a record has been added to a table it is not possible to "undo". You would have to delete the row. Make sure that your relationhsips are properly defined. Select the Enforce Referential Integrity option and then select the Cascade delete option for the relationship between orders and orderDetails. Then if you delete the order, the details will also be deleted.