Need help with order app

[gmagerr]

hi guys, I am trying to develop an application for my company's website. it's an application to enter and track jobs. and it's all going to be done on the site. ok i've created a database with several relationial tables here's what i have.

Materials
Employees
OrderDetails
Jobs
JobSite
Customers

Materials and Jobs are one to many to the OrderDetails
Employees is one to many to Jobs
Customers is one to many to jobSite
JobSite is one to many to jobs

ok, here's where i'm pulling out my hair. In the Employees table i have the info to logon to the website (username, password) once in the site i need to have it so the person logged in can enter a job. How do i make it so what they fill out get's put into the correct table? this is confusing to me.. do i make one huge form? if so how does the info get into the correct tables? if someone could maybe help me set this up (at least so i can get rolling) i'd really appreciate it. i don't really have any forms created yet, i did but i'm starting over with this new database. thanks in advance.

 

[krappleby025]

ok you can set uit up in many ways

1... you can use one full form, which will then on the second page add the info to each table by knowing what needs to go where

for example

one = request.form("one&quot
two = request.form("two&quot
three = request.for,("three&quot
etc etc

then you can have more than one query to insert the details for example

query1 = "INSERT INTO materials(one, two) values ('" & one & "', '" & two & "')"
query2 = "INSERT INTO employees(three, four) values ('" & three & "', '" & four & "')"
etc etc one for each table

or

2.. you can set up one form per page, which can then be altered if need be at a later time, making reach page vboth a form and the posting script for the previous page... this would be less confusing to do, and probably the better option

hope that helps

 

[gmagerr]

ok so basically what you're saying is have multiple forms (i did this earlier, and just passed the variables) and when you submit the first form, the processing to enter the data into the database will be at the top of the next form correct?

 

[krappleby025]

yes