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.
Conditional Drop Down options
-
- Posts: 7526
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
-
- Posts: 7526
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
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
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
Aware IM Support Team