I have a boy's list A, B, C and a girl's list a, b, c, both are in tables. if they want to pick a friend, if they pick up from a different list, no problem. in boy's table, A has a friend's field as dropdown list, with the data list as a,b,c to choose from.
But, if boy can only choose boy as friend, then the drop down's data list I want to make A, B, C available to choose, but that is my problem, what it only show is A, the only choice, because the repeated data and the data source is the same list, so the full list of A, B, C would not show up. \
How can I do that??