Restricted drop down list
I am using FMP 11 Advanced on a FMP 11 Server, and have a database in which one of the fields has a drop down that pulls from a separate database. But I want this drop down list to only show the item if it has not been retired (a field in the second database). I am not sure how to restrict the drop down list that way.
Thanks for your assistance.