You can set this up in Manage | Security...
Look up "Editing record access privileges" in FileMaker help, paying close attention to the section titled: "Entering a formula for limiting access on a record-by-record basis".
So here's where this thread ended up...I kept looking for a reply in the original thread.
Phil's right on top of it as usual...Thanks Phil!
In response to ebethram's reply:
I'm actually looking for something similar. I have a field that is written to by clicking on field label buttons, to display the definition of the field. It works fine in full access mode, but in guest mode (read-only), the user has insufficient privileges to write to the description field.
What I'd like to be able to do is give any read-only guest user write access to that one field. I realise there are "hazards" involved, but have made a "clear" button, which writes nothing to the description field when clicked.
Using FileMaker Pro 11.0v4 on a Mac Pro running Mac OS 10.6.8.
In FileMaker Pro help, under "Protecting Databases", appears the following:
Password-protect a file
Allow data entry only
Allow browsing but prohibit database changes
Restrict access to specific tables, records, fields, and layouts
I'm particularly interested in the fourth bullet: "Restrict acess to specific tables, records, fields, and layouts.
But there's no easy, direct access to instructions on HOW to restrict (or in my case, permit) access to a specific field.
My database does not have unique IDs per record, but it's simple enough to create a key field and populate it with serial numbers.
Basically, I'm checking to see if what I have to do is replace the exisiting field with a write-access field from a new table. That'll involve changing the button definiton for each of approximately 53 fields.
I'm attaching a screen shot of the database. I've since moved the instructions and right hand column farther to the right, so the data section is not so crowded.
Found the answer I was looking for in "The Missing Manual" for FileMaker Pro 11:
Edit [Guest] account
Privilege Set: New Privilege Set
Under "Data Access and Design":
Records: Custom Privileges
Layouts: View only
Value lists: View Only
Scripts: All executable only
Editing Records: Custom privileges: selected main table, where Field_Description field occurs:
View: Yes Edit: No Create: No Delete: No Field Access: limited
Editing Limited Field Access:
Clicked on Field_Description, changed to "Modify"
All other fields are set to "view only"
That seems to do it. Field level access is built-in, you just have to dig to find it.