I am attempting to create a value list which dynamically displays "Active" people from a table. I have attempted to do this through a combination of TO and a table with a field containing the value of what is defined as active and having a relationship between the TO and the variable table. Unfortunately no luck. I saw some posts about tables and a global field, but the advice did not make sense related to what I am attempting to do. Again, new to Filemaker so while there are many cool features, items like this seem to be a bit of a downer when compared to Access.
Anyways, basically I am trying to have a filtered value list of people from a table by looking at a field called ACTIVE which will have a value of 'X' if they are active. Any suggestions of how I can accomplish this would be helpful.
Thanks in advance.