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