How to show only records a user has the ability to view.
Everything was working fine with my database, I have many accounts some of which do not have access to all the records in some of my tables. To prevent those records from showing up when the user opened a particular layout I had a script that ran upon opening the layout that performed a find to omit all files that were marked as "No Access".
Suddenly this no longer works.
Is there a better way to do what I am trying to do? If not, does anyone know why my solution is suddenly not working after months of working fine?