Hi

I'm trying to come up with way to have sequential number for one type
of customer (Lead) regular customer have another type of number.

I try to use the MAX(field_serial) function but it's only good with
relation, and I don't want to create another self linked table I have
already too much in the file !!

I can't use the serial number function from FM since the creation of
the customer (or lead) is done in a popup window using global field,
so at this point, there's no new record created (that's why I want to
use the MAX function +1... but it's no working

My customer table is an SQL outside table, so I can't do much about
this one.

those number will be sequential and will have to be reset every fiscal
year.

Guess what, I'm using the random function from 0 to 999 to create
some numbers, but often I'm so lucky that I hit double every 2-3
days !! and that cause problems... (note to myself, buy some lottery
ticket!)

Any clues ??

Thank you

JF

In article
<b91e4056-926b-44af-b424-f75c44c60928 (AT) r27g2000yqb (DOT) googlegroups.com>,
Bizouman <bizouman (AT) gmail (DOT) com> wrote:

I think you're stuck with using a new Relationship, no matter which way
you then calculate the new ID number.




Helpfull Harry )

On 7 juin, 21:19, your.n... (AT) isp (DOT) com (Your Name) wrote:
Thank you !! That's what I did... add another relationship !! and it'S
working.... but my visual link diplay is getting loaded !!

"Bizouman" <bizouman (AT) gmail (DOT) com> wrote

On 7 juin, 21:19, your.n... (AT) isp (DOT) com (Your Name) wrote:
I did think of another possibility later. I haven't tried it, but it might
be possible to use a Summary Field instead of a Relationship.

- Create a Summary field to work out the maximum current ID
s_MaxID Summary, Maximum of ID

- Set the ID Field to Auto-enter by Calcualtion using the
Get Summary function to (hopefully) grab the value for the
current customer and add 1
ID Number, Auto-enter by Calculation
= Get Summary(s_MaxID; Customer)
where Customer is the Field used to uniquely distinguish each
customer.


Helpfull Harry )