How can I limit Choice List based on value in another field

[Tim Wmson]

In our Purchase Order form we want to select an approver from the User table who has the proper approval authority. We   have an integer field in user that indicates authority level and want our PO form Approver choice field to show only users with the proper level of authority. Can anyone point me in the right direction?

[edwin_munoz]

Hello Tim,

Please take a look at reference qualifiers. You will be able to fulfill your requirement by using a simple reference qualifier.

Reference Qualifiers - ServiceNow Wiki

Thanks

[Tim Wmson]

Thanks! The Reference Qualifier works up to a point but I want to restrict the choice list based on the user table approval limit table and also only show people who have authority to approve the total amount field on the PO form.

[Mike Allen]

In the dictionary of the field, you want to specify the level:

[Tim Wmson]

I've specified the approval amount field on the user table greater than $20k for an approval amount and that works, but is it possible to specify   "the approval amount on the user table greater than thee value of the PO Total field on the PO table" via a reference qualifier?