I have a page that pulls info from a database:
The current page orders all records by ARRIVAL. User clicks on PATNUM and it sends the PATNUM to a new page and creates a page that displays data for that specific PATNUM:
Everything is in one database.
User wants the case specific page to show a "position number" for that case based on SCHTM field. So let's say Surgeon A has 10 cases, Surgeon B has 8 cases, and Surgeon C has 4 cases.
When the case specific page is printed, the system would look for all records for that day that have the same surgeon, put them in order of SCHTM and tell me if that specific case is first, second, third, fourth, etc for that surgeon.
If a new row is added, it would update that position for the case.
What I'm looking for is how to do this - not necessarily the code for it. Just the steps to do it. I can do count for the surgeon to see his total number of cases for that day, but how do I get the number of the position for that specific case? Do I populate data to an array?