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?