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?

[bernyalvarado]

Great to hear Tim!   Have a great day!

Thanks,

Berny

[randrews]

when i am building a ref qualifier i always cheat... start by going to the user table with a test case...

then use the condition builder to filter the table by that test case... copy the query <right click the last bread crumb and select copy query>

now you can put the query in the ref qualifier exactly and verify it gives you the same results you got on the table.. then you can replace the constants you used with the variables...

this process allows you to first get a working query ... verify it works in place.. then step by step replace the constants so if you have an issue you will know exactly where the issue is... if it is referencing the table.. getting a variable in etc....   plus you don't have to worry about misspelling a   field name in the query.

[Tim Wmson]

Great idea! Thanks!