Partial data submitted to Access database

stara — Fri, 28 Aug 2015 12:12:24 GMT

Hello,

We've an Infopath form using data connections to Access database. Recently, when user clicked submit, only partial data was submitted to the database. The connection SQL uses multiple tables. Table 1 is linked to Table 2.

When user submitted data, only data was transferred to Table 1, but no data was transferred to Table 2.

Any thoughts on why this may have happened and how to prevent the issue from happening again?

Thanks so much

Stara

Data Connections

Partial data submitted to Access database