Re: To return query result in SQL

santhoshp — Mon, 29 Sep 2008 10:17:25 GMT

Hi Jollybaba,

Follow these steps to get the drop down values by querying a DB using secondary data source.

1. Go to Drop-Down List box Properties

a. Select 'Look up values from an external data source' radio button under List box entries.

b. Select the secondary data source in Data source drop down.

c. For Entries field Select the column from which you want to get the values into drop down list.

2. Add a button and set a rule to query the DB.

To return query result in SQL

Jollybaba — Mon, 08 Sep 2008 10:05:23 GMT

I am new to infopath. I have a sql db as a secondary data source. I want to send a query with a button and add that generated values as the lookup values to dragdown box. Is that possible?

SQL Database Integration

Re: To return query result in SQL

To return query result in SQL