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!