AnsweredAssumed Answered

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

Question asked by jlwayne on Aug 11, 2012
Latest reply on Aug 12, 2012 by glennsingleton

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)

Outcomes