Submit values from query of secondary connection to primary connec

[Ross B]

Here's what I'd like to do with an InfoPath form:

Step 1: Run a query on a secondary data connection (the connection is a
query in an Access database)

Step 2: Allow the user to input data about the data returned by the query
(I'm envisioning a repeating table with a drop-down input field for each row)

Step 3: Submit all the data (data returned by the query + data input by
user) to the primary data connection (a table in the same Access database)

Is this even possible?

 

[Sandeep]

Hi..Ross B

Yes I think it is possible.
Query + New data submit.

While creating the main database Connection in the access you should select
1 field data type as "auto number" which is primary key for your table.

And try these steps below.

1. Select access database as main connection and create form.
2. View the data source and drag the data fields except primary key field.
3. Go to Controls and select button and double click on the button and
select submit option.

Now select data connections and create secondary data connection.
Select “Automatically retrieve date when form is opened†check box.

Now bind the “Primary data†fields and “Secondary data†fields.


I hope this will help U .