I need a sequential number field
I have a table "STUDENT" with student data related to a table "PROBLEMS" with a couple of dozen exam problems via STUD-ID key.
For the oral exam, I assign each student six problems by entering his/her name in the STUD-ID field.
What I need for the test paper layout (sorted by STUD-ID) is a field that contains a sequential number (1-6) in the order I assign the problems to each student so I can print:
Another use is in post-exam comments, such as "Problem <<4>> was solved creatively…"
Thanks in advance,