4 Replies Latest reply on Aug 12, 2012 2:39 AM by glennsingleton

    Sorting records so a user has limited access to only his/her records within a populated table of many users' records

    jlwayne

      I have a table of records that includes fields for "ProjectNum", "Rep", "Date", "DaysWorked", "Desctiption" etc.

       

      I want a user to have limited access to only his records, with the ability to create new records or search (Find) records only with his RepID.

       

      What is the best approach? Should I create a script that sorts upon entry or create a separate layout for him...?

       

      (FMP12)