Filtered Value List
I have an employee table. I would like to create a value list that only showed employees that are current with the company. I want to filter out terminated and resigned employees. I want the value list to only show people who currently work for the company. While it seems a conditional value would work, I don't want to have to select Full-time, then get the list. I just want full-time employees from the value list...is this possible in FM 11? If so, how do I do that?
Thanks for your help!