-----Original Message-----
hey i am making an rma page for my company i have gotten
the database created and everything works fine, but i was
wondering is it possable to start with a number ie 1000.
thats the starting number i want the number to increase
by one everytime someone submits the form, then i would
like it to send a confirmation to the person that
submitted it..the number generated will be the rma
number, i know once i get that figured out i can create a
search page for them to find the status of there rma
number, wich i will be able to edit with the database
editor..it is my guess that it will take some coding in
vb or something, ie integerrma=1000 if submit=true then
integerrma=integerrma+1 or something,
Access can generate your RMA number if you define a field
as AutoNumber. However, I don't believe you can specify a
starting number other than 1. You would have to insert and
then delete 1000 fake records. In SQL Server, you would
set up the field as an Integer with Identity=Yes and
Identity Seed=1000.
Unfortuantely, FrontPage doesn't have a slick way of
retrieving the value of an AutoNumber field and displaying
it on a confirmation page. You must either modify the ASP
code that FrontPage creates, or code your own page in ASP
or ASP.NET.
Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*