How do you order more than one toy on each order on this database? I just purchased Access Application Development by Helen Feddema and I cannot figure out how to order more than one item per order. Was this database designed this way or is it me. I see no Order Details table like in the Northwinds Database sample that comes with Access
Thanks
Scott

The Toy Workshop database was primarily intended to illustrate how to do various programming tasks. To use it as a full-featured business database, it would need some customizing. To support ordering multiple toys on one order, you would need to add an Order Details table (tblOrderDetails), and put most of the fields from tblOrders into it. tblOrders would be related to tblOrderDetails one-to-many. Then the main Orders form (fpriOrders) would need a subform bound to tblOrderDetails to show the details for each order.

This would work somewhat like the Customer Phones and Customer EMails subforms on the Customers form.

Helen Feddema
Kerhonkson, NY
[email protected]
http://www.helenfeddema.com
Read Woody's Access Watch
http://www.woodyswatch.com/waw/