AnsweredAssumed Answered

Can a Value List Do this?

Question asked by rgnant_1 on Jun 7, 2018
Latest reply on Jun 8, 2018 by philmodjunk


Consider schools and sports

School 1     Football

                   Basketball

                   Badminton(L)

School 2     Football

                   Track    

                   Fencing(L)

School3     Football

                  Baseball

                 Badminton(L)

 

Now a list of people.  A field indicates Male or Female.  Based on the sex of the person, how to display the sports available to just that sex, with no duplication of sports.

 

That is, for Males the list would be Football, Basketball, Track and Baseball

For Females the list would be Badminton and Fencing.

Outcomes