submitting repeating table data to an access database

[gsn9877]

I have an infopath form that has a repeating table. How do I submit all
lines of data to an access database. Currently it seems to only capture the
first line item.

THANKS

 

[Clay Fox]

You would need a subtable I think.

Typically if you have items that will repeat within your main structure then
in Access you would need a primary table and a child table.

Then in InfoPath you can have multiple children to each parent.

Or you have this already and you are trying to copy multiple items from a
secondary source to your main. You need code to loop through and insert more
than one record based on repeating secondary data.