1 Reply Latest reply on Apr 19, 2012 12:56 PM by philmodjunk

    Setting privileges



      Setting privileges




      I am using FM Pro 11. I want to set up an account so that it allows the entry of new records, but does not allow the modification of previous ones. I set the record privileges to: view:yes; modify: no; create: yes; field access: all.

      However, it is only allowing that account to view records.


      Any help will be gratefully received.

        • 1. Re: Setting privileges

          You'll need to decide what value in what field marks a record as "locked". For example, we have an invoicing system where putting the text "printed" in a status field locks the records--both the invoices and a related table of line items against changing by all users not logged in with a full access password.

          This is called record level access control. See "Editing record access privileges" in FileMaker Help and check out this particular sub section: "Entering a formula for limiting access on a record-by-record basis" for a detailed description of how to set this up.