Define which rows to show in Enum from ref

[Phil_Waite]

Hi,

I have an enum of Product Ids to input orders into an order detail table. The Enum comes from the ref row type in the table “order details”. I would like to limit the options in the enum list to only show product ids where that product has more than 0 in the [Total Available] column in the product table. I’m not sure where I should be putting the expression before working out what that exoression should be.

thanks

Phil

[Steve]

The list of options presented in a dropdown menu is typically controlled with a Valid if expression:

help.appsheet.com

Dropdown from Valid_If

How to create a dropdown that depends on a particular list of values.