6 Replies Latest reply on Jun 21, 2013 8:36 AM by mike.goss@citta.co.uk

    Value Lists

    mike.goss@citta.co.uk

      Title

      Value Lists

      Post

           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?