Now I'm trying to assign students to 'Bd1", "Bd2", or any count of BdAlt1....5" based on:
So-- instrument = alto saxophone
event = d11 hsb
rank = 1......53
There are 6 separate events, and I need to assign students to each based on event, instrument, and rank
How do I assign the first 4 to "Bd1", the next 4 to "Bd2", 9th chair to "BdAlt1" and 10th chair to "bdAlt2"?
By the way , these are radio-button choices from an already-existing list. I'm willing to modify as necessary......................
I would say since there are a known number of seats you could just use calc fields. Should be easy.