conditional list

[Spanner_east]

I have a Sales file where I can choose a product from a value list defined from a Product file. I have products in my Product file that have been withdrawn that I don't want to appear in the value list but I still want to show in the Product file.

Is there a way I can only show the current products without choosing anything from the Sales file to define the value list?

[QuinTech]

Hi, Spanner. There are a few ways to do this. How do you currently get the value list in the Sales file? That is, do you select "Use values from field" or "Use value list from another file?"

Jerry

[Spanner_east]

Hi Jerry ,

I am using value list from another file. The products have a withdrawn field in the Product file...When the product is withdrawn a dropdown can enter 'withdrawn' or stay empty for a current product, I want to show the products with an empty withdrawn field.

Thanks

[-Queue-]

In the Product file create a calculation text field of Case( IsEmpty(Withdrawn), productfield ) and use this field for your value list.

[Spanner_east]

Thank you very much!