I am hoping to get some help with a wait list I am trying to create.
I have a wait list which tracks students that want to attend a particular camp but their instrument is currently full. For example, someone wants to attend Jazz Camp on Drums, but Drums is full. There may be multiple instruments for each camp that are closed but a persons position on the wait list is determined by the number of students who have already been placed on the list but play the same instrument.
Records on the wait list are created through a portal located on appropriate record the CAMP table.
What I can not figure out is how to do is to create a number that represents the students current position on the list, and have that number re-order when a person is removed from the list.
Thank you so much for your help in advance.