Binding Data to SQL

[smonczka]

Will Infopath allow you do use a secondary data conection as a lookup
table for a main data source?

For example I have two databases.

The Main database is a list of sales by date and sales rep.

The Secondary data source is a different database with list of just
employee names.

I want to create a dropdown list that pulls the names from the
Secondary, but i can use to quiery the Main data conection.

I have gone through several tutorials but dont seem to be able to find
an example for this senario.

Thanks for all your help,
Steve

 

[Adam Harding]

Yes it will

What you need to have on the form is a queryfield from your main database
bound to a drop-down list control.

Go into the Data Source tab open queryfields and browse to the field you
want. Select a DD-list box and position it on the form. Then as before bind
the default values to your secondary data source add a query button and the
data fields below in a repeating section/table if you need to return multiple
results and that will give you what you want.

Cheers Adam

 

[smonczka]

Adam, I am sorry for not writting back sooner but thank you for your
explination. I have been looking for a while for some sort of
explination on how this works.

Thank you,
Steve