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.