I need to create (lets say 100)new records in a multiuser database and need them numbered from 1-100. I use to use define fields but that won't work now that I am on Server5. Is there a calculation I can use in conjuction with a script and a couple of new fields?:

Thanks in advance.

Jeff

You need a global counter field (gcount) and a script:

code:

---

Set Field [gcount, "1"]

Loop

New Record/Request

Set Field [serialno, "gcount"]

Set Field [gcount, "gcount+1"]

Exit Loop If [gcount>100]

End loop

---