Updating changed field values across all tables?
I have a table of people information (First and last names, age, gender, etc.), and wish to create a dynamic value list for a second table that will contain all first and last names of the males in the "people information" table. I've read about conditional value lists, but cannot seem to get it to work. Does anyone have specific steps that will do this for this specific data set/type?