I have a system where multiple users work. They CRUD Work Order which is a Master and Multiple Childs sort of form.
Now, we need to have a way to retrieve previous versions of a Work Order. So that whenever some one update any of the MASTER or CHILDs column/row, it first copy the EXISTING data to a update history table and then update the live DB.
At the moment - we are just populating an HTML template with the data and storing the whole HTML in the DB for earlier versions. But I want a better way to do this as in case we update our template etc, the earlier versions of the workword will remain in the old html in the database.
What is the best way to do this ? Please guide !