Limit value list from field, by the value of a second field?
I have a table of people (fields for names, gender, etc.), and I have a value list that is defined from this table's "names" field. This list shows all of the names, regardless of gender. Is it possible to create a value list that only contains the names for Male people, or Female people, but not both? I cannot seem to get the "Include only related values starting from" feature for the lists to work in this way. This feature does not seem to limit the list by a pre-defined value. Instead, if I am on a Female's record then the list will grab the "Female" value and show all females in the list, and likewise for if the record is a Male then the same list will only show the males, but I want the lists to be separate and only show the "Male" and "Female" people regardless of the record I am on.