Reference only manager from sys_user

[cgedney]

I'm trying to figure out a way to create a catalog reference in which it only displays the managers.

I know there is a manager field on the department table, but how can I compare that field (Department.Manager) to the Sys_ID field on the sys_user here on the form?

Or is there a better way to create a reference field that displays only managers?

Thank you, Charles

[Jaspal Singh · Accepted solution]

Hi Charles,

There is already as solution for this in thread.

[DrewW]

As @Jaspal Singh indicated there is a solution for this that works but if you have a lot of people that are managers it can cause some slowness when the filter is opened and the like.  So what we did was add an "Is Manager" field that is set when the user is put into some ones manager field.  Then we just filter reference fields on that.  Thinks ran way faster after that.