Conditional Drop Down options

kwokm67

I have an object (Orders) that has two attributes which relates to objects - Items and ItemPrices. Items and ItemPrices objects are related.

On the Orders form I can select an Item from the drop down but how can I limit the drop down options on the ItemPrices depending what is selected on Item?

Please help.

aware_support

You need to define filter query. I believe this should be described in the How To document. Have you seen it?

kwokm67

Yes, I have seen it but I can't filter depending on ITEM selected because ITEM references a different table to ITEMPRICES.

aware_support

You need to define filter query for the "ItemPrices" attribute that looks something like:

FIND ItemPrices WHERE ItemPrices in Order.Items.Prices

(if Item refers to ItemPrices through Prices attribute) - this will make sure that whenever the user selects a particular item, only this item's prices will be shown in the ItemPrices drop down

kwokm67

All good. Thank you.