Hi. Assuming the dropdown menu is being used on a field on a layout based on the Order table:
1. Create a new field Order - call it "Active Constant" with a calculation equal to "Active".
2. Create a relationship between Order & Customer (create a new Table Occurrence of Customer if you need to) based on Order::Active Constant = Customer::Status
3. Create a value list using values from field: "Customer::Customer Name" including only related values starting from Order.
Have attached a simple sample file.
Active Customer.fmp12.zip 66.1 K
Thank you very much!!!! I was so close... in fact I was certain that I had setup exactly the way you described... So I delete the relate fields and restarted and it worked!!
I have been able to modifi it so that I can show ACTIVE or INACTIVE with a second drop down menu but is there a way for it be :
Thanks again for your help
Thank you, I am experimenting with Mailit, which seems to be a plug in that solves my issue. I was hoping for a solution within filemaker itself but from what I have read this seems to be the best solution.