Hello all, I am new to the forum.
I am having troubles linking or connecting two data connections. I am connecting to a SQL server through UDC in which the information could be accessed through the net. I have 2 separate connections with specific queries.
First connection is company which has columns for COMPANYID, Name.
Second connection is contact which has columns for COMPANYID, Fullname . . .
Both tables are linked in SQL by COMPANYID.
I was able to create a drop down list displaying the Name for any given company. When I select a company name, I would like Infopath to display the contacts associated with that company and re-query when a different company is selected.
I have tried filtering, but could only get it to work when I display the COMPANYID in the drop down list which is meaningless information. Any help would be greatly appreciated. My brain cells thank you all.