You could use CURRENT_USER to look up a table that has their
level, returning ( from another table ?) job titles of lower rank. Use
this for populating the list/box.
"Brad M." <officespaceatshawdotca> wrote in message news:%238jafpASDHA.1688TK2MSFTNGP11.phx.gbl...> Lets say I have a privilege structure organized by number:
> 1 - Administrator
> 2 - Office
> 3 - Supervisor
> 4 - Field Operator
> 5 - Assistant Operator
> Levels 1, 2, and 3 have the ability to add new employees to the system.
> However, when adding these new employees, I don't want them to have the
> ability to add a user with a higher level than their own. For example, if
> an office person with a user level of 2 adds an employee, I don't want them
> to be able to see the '1' in the list. If a supervisor adds an employee, I
> don't want them to be able to see '1' or '2' in the dropdown list. Is there
> an easy way to accomplish this type of 'filtering'?
> Any help is greatly appreciated.
> Best Regards,