Hi Steve,

If I understand correctly you would like to create an InfoPath form that is
*not* bound to any database but would have its data in the proper format
(relationship) such that the resulting XML files can be imported into an
Access database...is this correct?

Assuming I have understood correctly, try the following sample steps and
see if this helps:

- Create a new, blank InfoPath form
- Display the Data Source Task Pane
- Right-click on myFields and choose Add:

    - Name: Orders
    - Type: Group, Repeating
    - Click OK

- Right-click on Orders and choose Add:

    - Name: txtOrderID
    - Type: Field
    - Click OK
    - Repeat and add fields: txtCustomerID and txtOrderDate

- Right-click on Orders and choose Add:
   
    - Name: OrderDetails
    -  Type: Group, Repeating
    - Click OK

- Right-click on OrderDetails and choose Add:
   
    - Name: txtOrderID_Details
    - Type: Field
    - Click OK
    - Repeat and add fields: txtProductID, txtProductDesc, txtQuantity,
txtPrice

- Click and drag the "Orders" node to the form and choose Repeating Section
with Controls
- Right-click on the Repeating Table control that was created (this is for
OrderDetails) and choose Repeating Table Properties
- Select the Display tab and click the Filter Data button
- Click Add and then complete the following:

    - 1st box: txtOrderID_Details
    - 2nd box: Is Equal To
    - 3rd box: Choose Select a field or group and select the OrderID field
from the Orders group

** NOTE: What this is doing is "filtering" the OrderDetails group to only
show those records where the txtOrderID_Details value matches the
txtOrderID field in the Orders group.

- Right-click on the txtOrderID_Details field in the Repeating Table and
choose Properties
- Click the "formula" button next to the Default Value field, click Insert
Field or Group and select the txtOrderID field from the Orders group
- Test!

Obviously this would need some additional fields, formatting, etc. but
hopefully this gives you an overview of how this can be done.

I hope this helps you!

Scott L. Heim
Microsoft Developer Support

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