Newbies dscott23 Posted September 6, 2012 Newbies Posted September 6, 2012 I've read a couple of posts about locking down specific records, what I need to do is lock down a specific field so that it cannot be edited. I figured out HOW to do this and it works fine, using a couple of scripts. My issue is: When I set the field up and select none of the field entry options, this allows no editing of the field. My scripts add data/information into the field without issue. The problem is once you uncheck all of the field entry options, it eliminates the vertical scroll bar so we can not see the information in the field once it fills the window on the layout. Attached is a sample file that hopefully illustrates my situation. Two fields Note_Entry and Note_View. User types into Note_Entry then clicks in Save and the data moves from Note_Entry to Note_View. I need to set up Note_View so that someone cannot go back and change add or delete a previous note. Thanks. Tried to attach my sample DB, but was denied: Stripped for testing Fixed.fmp12 You aren't permitted to upload this kind of file
No_access Posted September 6, 2012 Posted September 6, 2012 You need to ZIP your file to attach it and witht out seeing your database, what I do is create a lock field and for the field i want to lock, under validation by calc.. isempty(lockfield)
comment Posted September 6, 2012 Posted September 6, 2012 You should be using the file's security settings in order to deny users' editing privileges for a field.
Recommended Posts
This topic is 4460 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now