I have a quote program I have made and i'm looking for a way to lock the records once it has been approved. I have a form that is filled out and a calculation that is done based on the fields that are linked to an sql table. What method could I use to lock an estimate once it has been approved? Thanks in advance.
You test if the value is set or not.. if it is dont let them change it
Or, you have to use multiple accounts within the app to connect to the database and have a special account that moves the record from one table to another where the second table is read only.. but thats complicated and leads to issues as you have more than 1 table to look up on.
well they can only update the record if your code lets them, so in your code allow them either to only hit save if the flag is not set, or, only run the save code if the flag is not set..
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Unsolved 
