view data from one table update and save to another table

[Bloggsy]

I have a tabl do this without amending te with item data which I sow on a
form to create a purchase order, where the item data may require amending
before publishing to the supplier. How do I do this without amending original
data which for audit purposes must remain as original.

 

[KARL DEWEY]

Not sure I understand what you want but what about append new records with
datestamp and Remarks as to why change when you apply a change? Have your
queries pull only the latest records.

 

[Bloggsy]

Hi Somewhere my key strokes fell into a pit! I have item data on an original
table which is pulled into a draft purchase order and which may be changed to
make more sense to the supplier. The original item data on the original form
must not be changed by this process though and the new data should be saved
to another table relating to the purchase order only. If I create a new table
query the amended data is then overwritten by the next import which is also
no good.

 

[hemant]

I have a tabl do this without amending te with item data which I sow on a
form to create a purchase order, where the item data may require amending
before publishing to the supplier. How do I do this without amending original
data which for audit purposes must remain as original.