Re: InfoPath to query SQL tables and return multiple values

Jess154 — Tue, 04 Jun 2013 19:27:44 GMT

Nevermind...I figured it out when I used a database template to build it off of.

InfoPath to query SQL tables and return multiple values

Jess154 — Tue, 04 Jun 2013 16:27:59 GMT

Hello,
I have an InfoPath form set up to retrieve data from a SQL table. I have a repeating table with text fields PartNumber, PartNomen, PartDescrip and SystemPartNumber outside of the repeating table that is the driving field for table query.. If SystemPartNumber=1234, I need the query to display all results in the repeating table to the corresponding fields. I have the following default value on PartNumber "@partNumber [SystemPartNumber = @systemPartNumber]" and it displays only the first entry from the SQL table. If I set the same value as a rule on the Query button I get the same result. It works correctly if using a drop down list but I need all the data returned all at one glance. What am I missing? If I don't need it to be a repeating table, please let me know the alternative. Thanks in advance!

SQL Database Integration

Re: InfoPath to query SQL tables and return multiple values

InfoPath to query SQL tables and return multiple values