filtered conditional value list

[lsaboley]

Hi all 

 

On my inventory database i have a conditional value list for removing products from inventory. 

on my customer order i can choose the product then from a pop up menu i choose a batch # that is associate with the product chosen. Then i can choose a warehouse based on the batch # chosen and so on. 

My problem is that some products are received much more than others so therefore have many batch #'s associated with them. My pop up menu for the batch #'s is getting very long for some products. 

How can I filter just this one value list to only show me the batch #'s that actually have a quanity of more that 0 in stock? 

 

thanks for any help

Lynn

 

[Matthew F]

Create a relationship that includes the number of items in stock as a match field.   Your relationship graph would look something like this:

 

 Table1::NumberInStock > Table2::Zero. 

 

"Zero" is a calculation field that is defined as 0.  "NumberInStock" is a field that gives the number in stock for an item.  Create a Value List of the Product Names or IDs, but through the relationship, which will filter out items not in stock.