User list lookup
Hi
Is there a way to generate a list of users the admin user of an Organization can see? This would be the same list of users shown if the "Manage User" menu permission was give to the Org admin user
I have a requirement to assign a RO to the users that belong to a certain organization. This task must be initiated by a member of the admin group for that organization. The RO has a field to put in the user ID for the user the RO is being assigned. The problem is populating the users' list the admin user can access. In my case, the admin user belongs to the same organization
I tried with a Lookup field with a query like:
Column Names = usr_key,usr_first_name,usr_last_name
Lookup Column Name = usr_key
Lookup Query = Select usr_key, usr_first_name, usr_last_name from usr //(where act_key=123)
Column Captions = User Key,First Name,Last Name
Column Widths = 10,100,100
I ran into a problem with this approach since I don't know of a way to get the admin user's act_key into the query
thanks