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?

[Tim Wmson]

I'm trying to specify >= current.total_cost from the proc_po (Purchase Order) table with no success with either taht or proc_po.total_cost

[bernyalvarado]

Hi Tim, I believe what you're doing is right. Would you mind removing the ^EQ and give it a try?

Also... make sure you have not misspelled your column names

Thanks,

Berny

[Tim Wmson]

It didn't work.   Is it not working because the Reference   Qualifier points to the user table while the condition is trying to point to the PO table?

[bernyalvarado · Accepted solution]

Hi Tim, try this:

javascript: 'u_approval_amount>=' + current.total_cost

Thanks,

Berny

[Tim Wmson]

That worked like magic! Thanks!