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