Hello everyone! I could use some direction here. This is my setup thus far:
Infopath 2007
Connected to SQL 2005 database
3 separate tables. Vendor info, language combinations (translators) , and job ratings
All three tables are linked by vendor Id column. I can submit data just fine, and it all works as expected. For instance, John SMith lives at 123 Main street, does English to Dutch and Dutch to German translations (repeating table), and on the last job he did he got a satisfactory rating. If I do a search by name, email address, etc. basically any info that is located in the first vendor data table, then it works fine. But, I want to be able to search by language combinations as well. If I do a search for English to Dutch, then Infopath returns every vendor in the database, not just the ones that do English to Dutch.
I'll gladly provide whatever info is necessary to get some guidance. I've been googling and I'm really stuck on the final lap. Any thoughts? Can I provide any further info?
Thanks in advnace for any suggestions.