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

Title

I need a sequential number field

Post

Hi,

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 …

PROBLEM <<2>>

Do …etc.

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

 

Thanks in advance,

Otto

Outcomes