Query - rule assistance

[ACDC]

This has got to be a simple one, just can't seem to crack it.

I have a query that lists all regular users. Can someone assist me with a rule to filter the list so it does not show the user LoginName 'Admin' if the logged in user is not Admin

So , If the logged in users login name is 'John', then all RegularUsers are shown, accept the one where RegularUser.LoginName= 'Admin'

Thanks in advance

[tford]

ACDC,

Try this:

If LoggedInRegularUser.LoginName<>'Admin'
AND RegularUser='Admin'

Then
READ PROTECT RegularUser FROM ALL


Can you let us know if this works?

Thanks,
Tom