Security at the record level using rules

[sOuterbridge]

Here's the scenario. User A has security level "0"(Highest level)access and User B has level "1" access. Suggesting that a numerical selection rule be applied for security by applying a flag on each record. User A with "0" access would like to view all records. User B with "1" access will be able to see all records flagged as "1" or higher. Can I easily achieve this?; or even a plugin would do.

Thanks

[Chuck]

I'm going to call your user level flag, which I'm assuming is a global number field, gAccessLevel. Also, I'm assuming that the field that tracks the level in a record is called Level.

Use this script:

Go to Layout [ layout with Level on it ]

Enter Find Mode

Go to Field [ Level ]

Insert Calculated Result [ ">=" & gAccessLevel ]

Perform Find

Chuck

[sOuterbridge]

Thanks Chuck, I'll give this a try.