Please read the 4th message (4 of 5) in this thread:
It shows how to setup the privileges for your data entry personnel so that certain records are locked (i.e. can be viewed but not modified).
Instead of checking the status for 'complete' as in the example, you can check if the creation date on your record(s) is less than the current date.
I found that post and added a "complete" field with values: Yes, No. That was easy. I adjusted my privileges set and tried to see what happens when I open the database as the data entry person. I get <no access> on everything. I have three tables in the file. They are inter related. I think I need more specific instructions as I do not have this set up correctly.
Thank you in advance,
In the example, the field name is: "status" and it is checking for the value: "complete" not "Yes" or "No".
Can you post the script that you are using?
Hope this works for you…
I adjusted the fields. No difference. I think I am partly stuck on what to set in the custom privileges area for View, Edit, Create, Delete and Field Access. I assume that once I hit the complete button on the record (which will be related to records in a total of three layouts) they will be closed. Currently I have View:Yes, Edit:limited, Create:Yes, Delete:NO, Field Access, All.
Am I close?
Yes, very close…
Here is the whole thing from the start:-
In the "Edit Privilege Set" dialog box:-
Under "Data Access and Design"
• for "Records:" select "Custom privileges…" from the pop-up menu
In the "Custom Record Privileges" dialog
• select your table
• for "Set Privileges:" choose "limited…" for the "Edit" pop-up-menu
Enter your test for the status in the "Records can be edited when" dialog box.
• for example: Case(your_table::status = "complete" ; 0 ; 1 )
Debra Singer wrote:
I assume that once I hit the complete button on the record (which will be related to records in a total of three layouts) they will be closed.
When you complete the entry, an error message should be displayed and the changes you made refused.
I amaze myself. I had no access set for the layouts which meant I could not see anything!!! You are so helpful and so patient. I will give this a try this week. Interestingly I did not have to set privileges on all of the tables as they are related.
Thank you again,