Saving old and new data in 2 different tables

[Dresse]

Hello,

I am trying to save data to one acces database, but in 2 different tables. I use a bindingnavigato r to view, edit, delete, modify my data.

Now the data is about recipes, so has alot of fields that contain numbers of ingredients. If the user makes a change in one of these recipes, the OLD recipe should be stored into an archive table while the new data gets stored in the original one.

This is too prevent a castastrophy when the new recepy is wrong, so they can just fall back on the old one.

I'm not an expert with visual basic, but i guess i know my way around.


Any help would be greatly appreciated,



Thanks!
Dresse

[debasisdas]

what is the problem you are facing.

you just need to insert into one and update the other.

[Dresse]

If the user has filled in different values for the fields, then how can i use a query to get the old values into the archive when he presses save? Cause the archive is a copy from the original.

So I guess I need to update the archive before the new is updated, but i'm not so good with sql statements. So I can't really get a right syntax for it. I'm using a acces database.


Dresse