AnsweredAssumed Answered

I need a sequential number field

Question asked by otto_m on May 14, 2012
Latest reply on May 15, 2012 by otto_m


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:

PROBLEM <<1>>:

Find …


Do …etc.

Another use is in post-exam comments, such as "Problem <<4>> was solved creatively…"


Thanks in advance,