Customizing Autonumber

[Guest_imported]

Is there a way to customize an autonumber? I have a table and I made the primary key an autonumber but I want the format of the autonumber to be WB2002-[####} Thanks


i.e.

WB2002-0001
WB2002-0002
WB2002-0003

 

[MichaelRed]

not and come close to having an autonumber. from the simplistic example, you COULD just use a standard AUyoNumber and prefix it's display with the "Wb*" stuff.

for a bit more than you ever really want to know about less simplistic versions, see faq181-261



MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over