way to save data for revising later but read-only when completed

[mtabt]

I need a way to allow restricted users to save their partially inputted data into a form to be revised at a later date. However, once the input is completed and confirmed, they cannot make changes anymore, thus the data become read-only for them.

Is there a simple way to implement this feature. Any help would be appreciated. Thank you in advance.

 

[rdodge]

One way how you can address this issue, which would normally be done in the planning stage of setting up a DB file/program, include a Status Code field.

Example:

Work Orders are created as jobs comes in to be performed. Occassionally, there's a job that comes in, but not all information is available to complete the creation of the work order ticket. The work order table uses the following status codes

05 - Created, but not enough information
10 - Created and information complete
20 - Work Order ticket is approved
30 - Work order ticket released for ordering
35 - All materials has been ordered
40 - All materials are recieved
41 - Some materials has been released
42 - All materials has been released
44 - Partial Complete
46 - Work Order Completed
90 - Work Order have been verified for Accounting to begin it's process (I.e. Job costing).
95 - Accounting Verification takes place
98 - Work Order has been Cancelled for some sort of reason
99 - Work Order has been fully completed and accounted for, so it is now closed out.

Note above, it's via the Work Order status code that controls what certain people can do with the work order at certain stages as the work order progresses though the system.

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000