It is possible. You will need two tables, the main one and the one to review changes.
Main table, BeforeEdit event. Instead of editing the record add a new record to changes table adding an ID of the record in the main table. To prevent the record from being edited do return false; at the end of the event.
Admin goes to the changes table, reviews the change, checks off 'Approve' checkbox and saves it. In AfterEdit event you need to check the value of 'Approve' field and if it equals 1 find the record in the main table and updated and then delete the record in the changes table.
I may have a template for exactly what you are looking for. I am in the process of submitting this to the xlinesoft marketplace for approval in 10.2 or 10.3 ( in design - October / Nov ) ( 9.8 output is available through my website - see below ) and has been in design and upgraded for 10 years. You can also visit formsdatapro.com . Look at video and fill in demo form , if you want to test the project. I will send you demo url and credentials for you to test. It was originally made for the Wine & spirits industry but you may like the modules that you see and we can customize with your industry . It was desgined in 9.8.[size="4"] Website Link Here[/size] . Also look at the video it may give you some insights even though it may not relate to your industry . It is customizable for you or I can customize.
The Template : Has Inventory control and management , Bookings by sales . employee etc...Department head approves bookings and Inventory deducts . Many more modules just to explain here . All emails to department heads are generated on the fly with an admin email module once approvals or low inventory is processed.
As far as your comment on approvals , all employees / users who book do not have access to approve , The manager / your department head has a seperate edit page to make approvals / reject or put in allocation mode and even assign others to facilitate your process. Once approved the data goes into another table for reporting and charting . Therefore yes request go to one table and approvals . If an approval is eventually deleted , our project Archives it into even another table .
