I offered to do a favor for a friend and would like some advice. He has a primitive order form on his web site. It is a table with 50 items, prices, etc. Each line has an entry field for the quantity ordered. When the form is submitted he gets a series of numbers, which then have to be matched to the items by pasting onto a spreadsheet. It is a very labor intensive, and awkward for the customers as well.
The desired product would be an form that is either on a fixed length table or similar to a datasheet, where a line is added when an item is ordered, and a dropdown is used to select the next item. The datasheet style would be very similar to the ?Order Details subform? on the MS Northwind database sample. The form would save a username, date, order number and quantity ordered into a table.
I have done some database work (Access, some SQL) and some web work, but combining them is getting over my head.
What I know:
How to construct a form/subform in Access that draws from tables, queries, etc. with calculated fields.
How to add a database connection to a web site.
How to direct form results to a database using Front Page.
How to use the Database Interface wizard to set up a form/database relationships.
How to duplicate the form/subform effect by sending the results of one form to another.
What I don?t know
How to set up a form with a dropdown item that updates more than one column (description, price, etc.) when one choice is selected.
How to draw product info from one table into a form and then post the order results to a different table.
Probably a lot more that I need to know but don?t.
What would you recommend for achieving the following results?
1. Posting of orders directly into a database table (or preferably two tables – orders and order details)
2. Easy updating of full product information on the form.
I know this is asking for a lot, so I am allotting a lot of points to distribute for good answers
