Access 2000 & AutoNum Feature

[Larry H]

Hi,

I am doing a Family Tree in Access 2000 and would like to
use Access to assign a NEW Family number ONLY when you go
to the NEW entry screen AND I CHECK a particular box
indicating that I wish to have the NEXT sequential humber
assigned. In between, on each screen I will be assigning
a number suffix to the original to get the effect that I
need.

Is there any way to do this in Access???

Thanks,
Larry H

 

[Douglas J. Steele]

Not with an AutoNumber data field. You'll have to write your own function to
figure out the next number to use. You should be able to use the DMax
function to get the last number used so far.

 

[Joseph Meehan]

Hi,

I am doing a Family Tree in Access 2000 and would like to
use Access to assign a NEW Family number ONLY when you go
to the NEW entry screen AND I CHECK a particular box
indicating that I wish to have the NEXT sequential number
assigned. In between, on each screen I will be assigning
a number suffix to the original to get the effect that I
need.

Is there any way to do this in Access???

Thanks,
Larry H

Autonumber is designed for one and only one use. That use is to provide
an unique number for each record. It does this rather well, although it has
been known to error from time to time.

You can't count on it to be sequential.

You need to write your own code to do what you want.