Multiple forms on one html page

[whyloo]

Hi

I am creating a website in Frontpage that posts information into three
different tables in Access.

Do I create three different forms on one html page, for each database
connection to a table?

My code looks something like this:

<form method="POST" action="--WEBBOT-SELF--" name="Employee">
<!--webbot bot="SaveDatabase" -->
Something something
</form>

<form method="POST" action="--WEBBOT-SELF--" name="Hours">
<!--webbot bot="SaveDatabase" -->
Something something
</form>

<form method="POST" action="--WEBBOT-SELF--" name="Allocation">
<!--webbot bot="SaveDatabase" -->
Something something
</form>

(This is for an online timesheet.)

Thanks!!

 

[Tom Gahagan]

Hello.....

If you know some asp you can just have one post method that posts to a page
that takes the form elements and puts them into the proper tables.

With a timesheet form you will need to do careful validation.... ie make
sure the name entered is a real employee, set up business rules for the
amount of time they could enter, etc. It might also be helpful to put up a
results page for the person to verify (the first form would post to this
page) and when the person verifies the info.. then post to a page the
actually puts the info into the tables.

And.... as with any online database product table locking at the time of
adding the data can be a real issue..... and remember that Access tables are
fine for smaller programs with not many users at any given time.

Having said all of that you might also check out some already done time
sheet scripts.
Take a look at the asp sections of

www.planet-source-code.com
www.hotscripts.com

Best to you........
Tom Gahagan