Showing only Active records in popup menu list
This should be an easy one for the great people here. I have a table of items. Items are marked with Active_Ind of "Yes" or "No". This Item table is then used in a popup menu list on another form. We only want to see Items with Active_Ind = Yes in the popup list.
I thought that there was a way to create a TO of Item with the condition of Active_Ind = Yes. If that is true than I can not find it. My second thought was to create a script that would find Items with Active_Ind = Yes, but then couldn't think how to connect that find set to the popup menu list.
Could someone point me in the right direction?
a FM newbie
You can either use a relationship where a field with a constant value of "Yes" is the match field to your Active_Ind field or you can use a calculation field that is empty when the Active_Ind field is not "Yes".
The calculation field method is "Option 1" in this forum tutorial on conditional value lists: Custom Value List?