Binding Data to SQL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

smonczka - 13 Apr 2006 18:09 GMT

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

Reply to this Message

Adam Harding - 19 Apr 2006 09:13 GMT

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

> Will Infopath allow you do use a secondary data conection as a lookup
> table for a main data source?
[quoted text clipped - 14 lines]
> Thanks for all your help,
> Steve

Reply to this Message

smonczka - 02 May 2006 21:17 GMT

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

> Yes it will
>
[quoted text clipped - 27 lines]
> > Thanks for all your help,
> > Steve

Reply to this Message