>I am trying to write a VB.NET 2005 app using a similar setup of the infamous
>Northwind DB.  I am using SQL 2005 Express on my laptop and will eventually
>upgrade to SQL 2005.
>
>My tables consists of:
>    Customers
>    Orders
>    OrderDetails
>    Category
>    Products
>    Suppliers
>
>My problem is:  Watching the webcasts on development using databases, they
>show how to create a fully functional (yeah right) app with related tables.
>They don't show how to add orders and order details related to the customer.
>For example:  Order Details table has a many-to-1 relationship with Orders.
>I have a GUI with the cutomer info, then the related table orders, and a
>group box with order details, how do I add Orders and Order Details to the
>customer?  The binding navigator allows me to add a user to the screen
>(that's the easy part).
>
>I guess what I want to know is what code do I need to write to add Orders
>and Order Details to the customer.
>
>The following links are pictures of my GUI for the orders form and the
>related binding info for the form in VB 2005.
>
>http://www.kingenterprises.dynu.com/images/Orders.jpg
>
>http://www.kingenterprises.dynu.com/images/dataBinding.jpg
>
>Thanks in advance for the help.
>
>Tony
>
>