Submit values from query of secondary connection to primary connec

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ross B - 20 Jan 2006 12:32 GMT

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?

Reply to this Message

Sandeep - 23 Jan 2006 08:20 GMT

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 .

Signature

Sandeep
www.autonomysystems.com

Reply to this Message