Limiting / Filtering What Records are Visible
I have a database in which only two layouts are visible to users through Custom privileges using the SponsorLogin = Get(AccountName) limitation. This allows a user, in this case a child sponsor, to only view those children that they have sponsored. The problem is, when sponsors log in they have to cycle through all the records that they are not allowed to see (which properly say "No Access") until they get to the one(s) they are allowed to see. Is there a way to avoid this cycling through the records and only let them see the ones they are allowed to see? I am using FM12. Thanks.