Placing form information into a new table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sorry about the attachments, did'nt know.

So here's my problem.
I am creating a Purchase request form that consists of several tables. My
main table is about the requestor, entered as I get a request. I then ask
where to ship the product and populate a subform from that drop down list.
I then gather what bundle they would like from another dropdown and populate
yet another subform, which then gives another subform it's allowed bundle
options. There is then yet another subform where any of the options that we
carry can be added on, just not at a special price. I'm using check boxes
to make those selections with in the table/subform.

My problem is when everything has been selected, how can I gather all the
information from the form/subforms into a new order table ?

I would like to add an adjusting order number to each order, but keep it the
same for all items in that order.

I know I'm saying a lot, but know better way then to rattel on about this
one.

I though I might be able to create a addend query that would be run by some
option button, say complete order. But do not see how I can build a query
out of subforms selected by a dropdown. Or how to take all the new
infromation that has been entered and know how to move it to the new table ?

If further details are needed I will provide what I can.

Any and all help would be gretaly appreciated.
I'm fairly new to this Access, but I'm trying.

Thanks,
Gregg Harris
 
I have done this a lot but each one is unique! Please
send a ziped copy to (e-mail address removed) and I will give
you some help, if I can.
 
My problem is when everything has been selected, how can I gather all the
information from the form/subforms into a new order table ?

I would like to add an adjusting order number to each order, but keep it the
same for all items in that order.
Click to expand...

It sounds like you started designing this database with the forms, and
now you're trying to work back to the tables. That's the *wrong way
about!* The Tables, properly normalized and related, are the
foundation of this house; the forms and reports are the doors,
windows, and paint job - applied *after* you have the foundation
correct.

It is probably *not* a good idea to consolidate information from
multiple subforms into one single massive order table containing all
the information. You can, and should, store information about each
entity (Order, Customer, Product, etc. etc.) in its own table; use a
Query combining the tables to generate "an order" - a sheet of paper,
generated using an Access report which draws on multiple tables. A
Report doesn't need to be (and rarely will be) based on a single
table.
 
Back
Top