hello!

i've got a form that has these fields:

txtFirstName
txtLastName
txtAge
txtStreetOne
txtStreetTwo
txtCounty
txtPostcode
txtFeedback

what i'd like to do is have the personal information (txtFirstName to
txtPostcode) insert itself into the USERS table when the form submits. i'd
like the txtFeedback to go into a table called FEEDBACK.

the reason for this is that i have several different forms on the site and i
want to keep the USERS table separate (there's will be a FEEDBACK,
COMPLAINTS, COMPLIMENTS tables eventually)

i've currently got all the info in one table called USERS that is getting
fairly unwieldy....

is this done by creating relationships between say a user id?

any help would be grand,

cheers,

jake

Jake,

The design of your forms does not have to reflect the design of your
database tables.

Secondly, the design of your database tables should be based on something
called an ER model (Entity Relationship model). After you have your ER
diagram, you design your tables, then normalise them if required. Any decent
book on databases should be able to cover this for you.

Personally I've found this book to be quite good:
http://www.amazon.com/exec/obidos/ASIN/0201708574/

Cheers
Ken


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "jake williamson 28" <jake.williamson@2...>
Subject: [access_asp] insert into two tables from one form


: i've got a form that has these fields:
:
: txtFirstName
: txtLastName
: txtAge
: txtStreetOne
: txtStreetTwo
: txtCounty
: txtPostcode
: txtFeedback
:
: what i'd like to do is have the personal information (txtFirstName to
: txtPostcode) insert itself into the USERS table when the form submits. i'd
: like the txtFeedback to go into a table called FEEDBACK.
:
: the reason for this is that i have several different forms on the site and
i
: want to keep the USERS table separate (there's will be a FEEDBACK,
: COMPLAINTS, COMPLIMENTS tables eventually)
:
: i've currently got all the info in one table called USERS that is getting
: fairly unwieldy....
:
: is this done by creating relationships between say a user id?

Hi
I have a field in a database which contains the date the data was entered,
Is it possible to take a count of the number of fields that has been entered
in the last 24 hours?

thanks
Brendan