I'm trying to set up a calculation field which creates a sequential series of data for all the records in a found set. I'll be using it to create numbered labels for test items in a printed test. Currently, after using a "find" function to create the list of questions I want to use in a test, I can manually type in 1, 2, 3, etc. into my "sequence" field. However, I'd like to harness FMP to do it automatically instead, to turn "seqence" into a calculation but am having trouble coming up with a calculation to do so. Now I'm wondering if I need to use a script with it (Find, then Sequence....)

Any ideas, suggestions or calculation scripts would be wonderful.

Thanks

Use a script to loop through the found set.

Chuck

Insted of a loop script, how about using the comand Replace (found under records) and check sequence or calculation. I think it will run faster.

This might be a simple way (if it is what you want). If you find the questions want, and sort them in the order you wish, you can create a field defined as a calculation (unstored) equal to Status(CurrentRecordNumber). This is just the number of the records in the current found set in the current sort order. Its kind of like a line number in list view. It is not really attached to a record, just a numbering of the current found set from top to bottom. Once defined, no additional action would be necessary.

-bd