Can you "lock" a record?
I've got a small problem. I have a database where I need the regular users to be able to go in and add and edit records - but only up to a certain point. I need to be able to change the status of a record so it goes from "in use", and users can edit it, to "locked", where only admins can edit it, on a record-per-record basis. Is this possible? I haven't seen anything in the users guide about anything like that.
The logic behind it is that each record is an order, and users can delete and edit it while it's still pending, but once it has been delivered, it's historical data that needs to be preserved as it was at the time of delivery.