Script to perform find in checkbox field
I need to have the user who's logged in (account name, I believe) have access to only those records that has that user's name in a checkbox field.
The file in question is a rolodex file. The thinking is that there is one, master file. The checkbox field includes various user's names. So then any given record could be accessible by one or more people, but only if their name is checked. I'm not sure if this can be done with privilege sets, so I'm trying to get a script working that upon opening the file, finds only those records with: the current account name = name checked off in a checkbox field. If I do a manual find, it always works, and of course my found set is just what I would expect. Any scripting I have done always fails (no records match this find criteria). I have tried a script that is basic: Enter find mode, Set Field, Perform Find. I also tried a script that uses a variable ($) in a find request.
I could be going about this the wrong way, so if anyone has some simple way to achieve my goal I'll be happy to say DUH! and I thank you very much.