2 Replies Latest reply on May 7, 2010 1:51 PM by AAgraphics

    Filtering records questions

    trouty

      Title

      Filtering records questions

      Post

      Hi, have a database with about 15 fields in which one of 5 different sales representatives gets entered into the "sales_reps" field.  Does anyone know how to filter records, so when one of these sales representatives logs in via IWP, they get to see only their own records?

       

      Any help much appreciated

       

      Trouty

        • 1. Re: Filtering records questions
          ninja
            

          Howdy trouty,

           

          You would control this in Accounts&Privileges.

           

          File>Manage>Account&Privs

          In the privilege set for your sales reps, on the left side, you have record privilege options.

          Choose Custom Privileges and set the calculation to:

           

          Table::sales_reps = Get(AccountName)

           

          Note (obviously) that the value put into the field has to match their login account name.

           

          You may also find it more convenient to put a "find by account name" step in your startup script.  This lockout process does not stop folks from seeing the record itself, but stops them from seeing the data on the record.  So they will come across a bunch of 'blank looking' records or fields with "<no access>" if you don't start them off in a found set by their account name.

           

          I also opt to put a "find mine" button on the layout that does a find in the sales_reps field for "Get(AccountName)" to help.

          • 2. Re: Filtering records questions
            AAgraphics

            I am using FMP 10.  How can you filter out the results that say <no access>?  Can you be more specific on how to filter out the records that say <no access>.