I have created an application where I restrict the records that the user can view / edit / report on based on security / privileges that use the users account name. This part works, but when I direct the user to the proper layout all the records are there with the ones they are not allowed to see indicating . I am trying to make it so all they see are their records and not the no access. I have been thinking if I can do a FIND based on user account then I should be able to get rid of the unwanted records.

The field where I am capturing the account name is called - "Created_By".

Any help would be greatly appreciated.

Thanks

You can make a script to perform find YourTable::Created_By[*], and in File>File Options put to perform that script "When opening this file". This will only show the cuurent users records.

Carlos B.