We have restricted users from editing records once they have created them. Is they a way to allow editing access to a particular layout (or field) without compromising the above mentioned security.

example- an invoice file has restricted editing access to all records after the original creation. We would like to allow a particular user to edit one field (which can be placed on any layout) at any time... however we don't want that user to have further access. thanks in advance.

Topic moved to Security Issues Forum.

When any field in a layout is restricted, the layout will be restricted. Pg 572 in the File Maker Pro Bible.

I think you need to grant access on the file level before you can restrict access on the field level. I haven't read anything yet to suggest otherwise...

One method I have used on several occasions is to duplicate the layout, one for creating the record - with access to all of the appropriate fields. The duplicate layout would be used for viewing or editing only, "allow entry into field" (in field format) for only those fields you want to allow the user to change.

Is what you are saying that a particular user can create a record but subsequently may only edit say one of the fields?

If this is the case you need to set up a layout where the user can enter data into global fields e.g gName; gAddress; gAge and then write a script to create and enter this data into a new record so that gName is entered into Name etc. The user could then view the records on another layout where you restrict access to the fields that you don't want to be changed. On second thoughts you can even put the viewing and entry fields on the same layout if you wanted since the script will only enter the data into a new record not the one you are currently viewing.