Hi Jamesy,

Then you should be good to go. When you created your InfoPath solution, you
created it from the database...correct? If so, you would simply need to
include the tables you need. For instance - let's take Customers, Orders
and Order Details. One customer can have zero or more orders and each order
can have zero or more line items. So when I create an InfoPath solution to
enable adding/editing these pieces of information, I first add the
Customers table, then the Orders and finally the Order Details.

Now if you are familiar with these tables, you will know there are other
fields such as EmployeeID, Shipper, etc. If you notice, I did not include
those in my "main" data source - these would be considered secondary data
sources and I would use them in conjunction with a drop-down list so the
user can simply select a Shipper.

So with my main data source consisting of Customers, Orders and Order
Details, I can add a new customer by itself or immediately include an order
with or without line items. In addition, I could query for, say, a
CustomerID and then modify all or any one of the tables. In each case, when
I click the Submit button the appropriate table(s) will be updated.

I do hope I am not making this more confusing for you. If this still does
not make sense, let me know and I will provide the steps to see this work
using the Northwind sample database.

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights