I am at a lost on how to take the row number that is displayed for interface purposes and use this number in a calculation. Somehow I need to create a field that first holds that row number.

Any help or ideas would greatly be appreciated.

Thanks,

-Shari

Have you tried using the Get(PortalRowNumber) function? I think we need to know what you're trying to calculate (and for what purpose) to provide more help.

The DB will be used at a race track for starting grid positions.

I have a DB with 2 classes (Novice & Regular) and a random number they chose.

I sort by classes and random number (ascending order).

Each class then has a set of numbers in order.

I Find each class separatly and use FM "Insert Record Number".

I want that record number to be there new random number that they choose. And then the new number is used in calculations to determine 3 other numbers.

I hope that makes sense.

Thanks for your help.

I am afraid that makes no sense to me at all:

What is "a random number they chose"? If they choose it, it's not random.

What do you mean by 'FM "Insert Record Number"'? I don't know of such function or a script step.

If you "want that record number to be there new random number that they choose" - why not leave it alone?