How to create a record sequence
I have a solution that imports a set of daily surgery appointments and then sorts them by surgeon for display on iPads. The patients are originally sorted by their surgeon and their set times, but sometimes during the day we have to "shuffle" them a bit. I would like to figure out away to (1) assign a sequence number for each patient under each surgeon and display it with their individual record, and then (2) if I get a new patient or if we decide to move a patient up or back in the sequence, re-number them and display the new sequence numbers.
Any ideas? I think I could do it if I only had one surgeon, but adding in the multiple surgeons moves it out of my league. TIA!