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


      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...?