Dropdown Ref with more rows to show

Hi All,
My Materials is a dropdown ref from the Product table. when filling up options from the product name dropdown, I would like to see the QTY of each item. so that if there not enough qty then I will exit the form. How can I do that? thanks

Does the product table contain a column for the quantity remaining for that product?

yes Suvrut. actually it is named [Total Available]

Please explore below.

Please create a VC with an expression something like CONCATENATE( [Product Name], " QTY- ", [Total Available]) and please assign this column as label column.

The drop down column should reflect with quantity as well.


Thanks, it works.