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?

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

OP indicates version 7 - no script variables there.

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.

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

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

RestartCount7.zip