AnsweredAssumed Answered

Value Lists

Question asked by on Jun 21, 2013
Latest reply on Jun 21, 2013 by


Value Lists


     Before I pull out what little hair I have left - help!

     I have a table PurchaseOrders containing details of all purchase orders on the system,

     One field in the Table is Status which can be either "Open" or "Complete" - there are others but let's ignore them.

     I have a layout used to edit PurchaseOrders

     I want the user to be able to select which order to work on by picking it from a drop down list of Purchase Order numbers.

     So far so good, I can make the drop down list show ALL purchase orders - BUT I want it to show only those order numbers where the status is "Open".

     I can't make it work, any hints?