AutoNumber(Rowno(),"Field Name") - Confusing result

[GaryMcDonald]

Hello, 

I'm trying to create multiple ranks using the script:  AutoNumber(Rowno(),"Quote Number") as Rank1 

This works on the main table as expected, however when I create a secondary table using a resident load and apply the same script (AutoNumber(Rowno(),"Quote Number")) as Rank2  but include a where clause "Claim limit Filter 2k" =1. The number  doesn't start from 1 it carry's on from Rank1?

I want to create 5 ranks based on the Limit filters.

Please could someone help in explaining why the result is a continuation and how I go about resetting it so each rank starts at 1?

Many thanks Gary

Data fields:

"UniqueID",
"Quote Number",
"Retail Price Pay Annually",,
"Claim limit Filter 1K",
"Claim limit Filter 2k",
"Claim limit Filter 3K",
"Claim limit Filter 4k",
"Claim limit Filter 5K",
"CL Filter 10k",

Exampl Date:

The below image is a snap shot of the result there are 141 rows.

[sunny_talwar · Accepted solution]

AutoNumber keeps the same number based on Quote Number even if you use it in multiple tables. Try this

AutoNumber(RowNo(), "Quote Number"&1) as Rank1

and then this

AutoNumber(RowNo(), "Quote Number"&2) as Rank2