Form kind of like shopping cart

B

bourdon

I need to build a form where a user can:

Pick a particular part (or search for a part then pick it)
Add a quantity to order for that part

Do this repeatedly until he has selected all the parts and quantities
for the various parts he needs to order, then hits submit (will
generate an email, I can handle that!:)

I just can't seem to get the parts he wants to display in a view or
subform each time he adds one.

So the subform would look something like this:
Part 233232 Qty 4
Part 32332 Qty 5
Part 31122 Qty 2

Submit
thanks for any help!
 
A

Al Camp

Bourdon,
Basically, you'll have two tables, tblOrders and tblOrderItems related by
a One to Many relationship.
tblOrders will contain all the One info, like a key unique OrderNo
(Autonumber) for each order, and any information about order and the
customer (the One).

Create a relationship between tblOrders and tblOrderItems, One to Many,
with Referential Integrity, and Cascading. The Join should be "Show all in
tblOrders and onlt those in tblOrderItems where there is a match"

Your main form will be based on tblOrders, the subform (continuous) on
tblOrderItems, and linked (Parent/Child) on the form via OrderNo.
 
Top