User changes in a table/form
If a User changes the data in a form/table, how can I find out excatly which row of data has been changed, and what it was changed from and to? (To will be recorded on the table, but that means that the old data will be overwritten)
The reason I need to know this, is for use with my warehouse stock database.
Everything works fine, as long as the user doesn't make an error, and have to correct an order. The reason for this, is that as soon as the data is input into the form, a series of calculations take place, telling the user which area of the warehouse the user should take the stock from.
If the user then edits the amount of stock required, the database will need to reset the data, and then recalculate where to pull the stock from(as there might not be enough stock in the area originally suggested).
The process I need to run through if the user needs to change the data is:
1) Add the original amount of stock pulled back to each area it was pulled from.
2) Change the status of the changed data from "Calculated" to "Requires Calculation"
3) Run the code that is activated if an order row has the status "Requires Calculation".
Hope this makes a little bit of sense.