Developer Forum

So I get the idea not to use the autonumber field for anything meaningful.

But - how do I create a sequenced or unique field when I am dealing with
replicas?

Seems random number generation would minimize the conflicts, but there is a
remote possiblity of a conflict, and giving a customer an invoice, location #
etc of 238982752398756 is cumbersome.

Sequencing poses a problem, since if I am tracking my numbers/increment, it
would be very easy to duplicate in a replication environment.

Could possibly suffix/prefix a sequence based upon which replica/master
being used, but this presents problems also.

Any ideas where I could keep invoice numbers in sequence while using
replicas where the replicas and masters are creating invoices???

Thanks..