I may be in the wrong topic forum here. This database is used by "Users" who add new records to the database each day. At the end of the day I want to lock those records so they can't be modified by the "User" the following day. There is an "Admin" login (Username: Admin, Password:Admin) for full access to all records, and a "User" login (Username:User, Password:User), which should allow new records to be added but old records can't be modified. To do this, I've created a "Lock" field that defaults to 1 with each new record. At the end of the day, the Admin changes all the lock fields to a 0 using a script (see script). Then the custom privileges for "User" is suppose to be set such that "if lock = 0" then access to those records is denied. I can't seem to get that to work properly. Any help here would be much appreciated.

Full Access - Username:Admin, Password:Admin

Limited Access - Username:User, Password:User

LockingRecords.fp7.zip

I would probably say to reverse it where the 1 is the lock and if its locked then prohibit modification of the record.

LockingRecords_Mod.zip

thank you

Automatic message

This topic has been moved from "Database Schema & Business Logic → Custom Functions" to "Database Schema & Business Logic → Managing Scripts".