HOW TO ID A FORM

[alec]

Hello,
Visitors to my web site are filling a form and submitting results to database.
I would like to uniquely identify each of these submissions. I know that
FrontPage provides an option to include a hidden TimeStamp field. Instead of
this field I would like to use unique number, for instance first submission
2005-0001, the next one 2005-0002 and so on. What code should I use in my
Form so that these unique id numbers would be posted to the database?
Thank you. Your advice will be greatly appreciated.

 

[Mike Mueller]

Easiest implementation would be to do it at the database end

Add an autonumber field to your database. There is also
information out on the net on how to 'preset' the autonumber
to whatever value you want, and then increment from there.


: Hello,
: Visitors to my web site are filling a form and submitting
results to database.
: I would like to uniquely identify each of these
submissions. I know that
: FrontPage provides an option to include a hidden TimeStamp
field. Instead of
: this field I would like to use unique number, for instance
first submission
: 2005-0001, the next one 2005-0002 and so on. What code
should I use in my
: Form so that these unique id numbers would be posted to
the database?
: Thank you. Your advice will be greatly appreciated.

 

[alec]

Mike,
Thank you for your response. I thought about this possibility. But I would
like to present a user with a confirmation form that will show among other
things customer's Order number (unique ID). I know how to use Web Components
--> Advanced Controls--> Confirmation Fields to tranfer info from Order Form
to Confirmation Form. But I do not know how to extract this unique AutoNumber
from the table of database ( I am using MS Access one) and tranfer it to the
Confirmation Form. Any suggestions?
Thank you.

 

[Kathleen Anderson [MVP - FrontPage]]

How to make the autonumber available as a confirmation field called 'ID'.
http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Autonumber