🚀 go-pugleaf

William Matthew Beaver <wb1o+@andrew.cmu.edu> writes:

>Is there a way to assign a unique integer to a field outside of the #N
>comand in the layout editor?  

the "standard" :-) way to do this is to have an extra file in your
database called Constants or Sequences. your sequence file has 2
fields: sequence name, and next number.  to get the next number all
you have to do is search for the correct sequence by name (or you can
number them if you prefer) and then use the contents of the next
number field;  before you unlock the record, you should increment the
next number for the next time you want one. the next number is always
unique for that sequence as long as you increment it each time it is
used. you may have different sequences for each file in your database,
and multiuser issues are not a problem (if you can't load the record,
you know someone else is using it. just wait until it becomes availale
again to get the next number).

--mike