In addition to receiving data from an Access database, InfoPath can submit
new or changed data back to the database. When you use the Submit command on
the File menu to submit changes to the database, InfoPath uses ActiveX Data
Objects (ADO) to update the records in the database. Form submission is
enabled when all of the following conditions are met:
There must be a base column for every column that is used in the form's query.
A table column may not appear multiple times in the entire query.
A primary key, unique constraint, or unique index must be available for
every table in a SELECT clause that's used in the form's query.
A table cannot be included multiple times in the form's query.
Relationships between parent and child tables must include all primary key
columns from the parent table.
There can only be one base table for all columns in a SELECT clause that's
used in the form's query.
There are some circumstances under which InfoPath cannot submit form changes
to a database. For example, if you create a form that draws data from a query
instead of a table, or if you customize the SQL statement used by InfoPath to
include a JOIN statement, InfoPath will be unable to submit changes. Another
circumstance that would prevent InfoPath from submitting changes is if you
were to add tables to the form that have a many-to-one relationship with
their parent table. In situations where InfoPath will be unable to submit
changes to the database, the Submit Status field on the summary page of the
Data Source Setup Wizard will display the reason for the limitation.
--
Kalyan G Reddy
INFOPATH MVP 2007 and 2008
http://www.ggktech.com