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.