a project of a lifetime Options

[darshil]

well, not really, but it will matter. i need to set up a form, where students have to choose their sport. Now you see, im fine with the form bit as i have already designed it with infopath 2003. this is the bit where i just bang my head repeatedly. i need to set up a server where the query is recieved and sorted. So if someone choose Basketball as priority 1, Softball as 2 and Soccer as 3 it will automaticall sort out which sport he/she can join. And that is sorted by importance. for example, if i am in year 7, i have the lowest priority as i get sorted/put into a sport last whereas someone in year 12 gets the highest priority. is it possible ? thanks a funkin million