Numbering Help!

[allied72]

I have a database that I need to print to forms, that are sorted according to three fields. ie

Company Name, Rep Name, Client Name, where each company has a number of Reps and each rep has a number of Clients. Each form will have a printed list of the Clients for each Rep and the Company Name and will be numbered sequentially, I need the number to restart its count when the Company name changes. Any ideas?

[Fitch]

Assuming you've already sorted by company and you want to renumber the found set, this script would do it:

Loop

  Set Variable[ $n ; Case( companyID = $ID ; $n+1 ; 1 ]

  Set Field[ sequence ; $n ]

  Set Variable[ $ID ; companyID ]

  Go to record[ next ; exit after last ]

End Loop

[comment]

OP indicates version 7 - no script variables there.

[comment]

I *think* this should work in version 7 too:

Define a summary field as Count of [any field that cannot be empty], Running count, Restart summary for each sorted group when sorted by Company.

[allied72]

Thanks for the help so far

I can't see where i set this part of the summary field

Restart summary for each sorted group when sorted by Company

[comment]

I am afraid I was wrong: this feature was added in version 8. Try the attached workaround.

RestartCount7.zip