I have a database that generates an auto number. Is there a way to add a
custom prefix to the auto number?

No, you would have write a custom script that create unique IDs in the format that you require. In
IE address bar type:

? ASP Generate Unique IDs

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Debbie Saffold" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have a database that generates an auto number. Is there a way to add a
> custom prefix to the auto number?
>
>

Hi Debbie,

Yes you can through code, i.e., the code will have to add pre-fix the to db auto number before it is displayed.


--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
J-Bots Plus 2002 87 components for FrontPage
http://www.websunlimited.com/order/P...p_help_dir.htm
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible

"Debbie Saffold" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> I have a database that generates an auto number. Is there a way to add a
> custom prefix to the auto number?
>
>

An example:

Order Number: XYZ- <% =rs("recNumber") %>

Where recNumber is the autonumber field in the database. Note you can also easily modify the DRW code to accomplish.


--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
Need to protect your web pages Page Protector Pro
http://www.websunlimited.com/order/P...ro/pagepro.htm
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible


"Debbie Saffold" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> I have a database that generates an auto number. Is there a way to add a
> custom prefix to the auto number?
>
>

However that is only workable if the same prefix will always be used and is only for display
purposes to the users visiting the site. It can not be used to as a lookup ID in the database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"MD Websunlimited" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> An example:
>
> Order Number: XYZ- <% =rs("recNumber") %>
>
> Where recNumber is the autonumber field in the database. Note you can also easily modify the DRW
code to accomplish.
>
>
> --
> Mike -- FrontPage MVP '97-'02
> http://www.websunlimited.com
> Need to protect your web pages Page Protector Pro
> http://www.websunlimited.com/order/P...ro/pagepro.htm
> FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible
>
>
> "Debbie Saffold" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> > I have a database that generates an auto number. Is there a way to add a
> > custom prefix to the auto number?
> >
> >
>
>