How do get an InfoPath query form to return multiple records?

[bbsoftware]

I have created an InfoPath form connected to an SQL database. Part of the
form allows the user to query the database. The queries are intended to
return multiple records, however the form only displays one record. How do I
set up the form to return multiple records from a query? I have tried
creating a repeating section and copying the form display areas into it, but
it didn't work.

 

[Paul Webster]

I have created an InfoPath form connected to an SQL database. Part of the
form allows the user to query the database. The queries are intended to
return multiple records, however the form only displays one record. How do I
set up the form to return multiple records from a query? I have tried
creating a repeating section and copying the form display areas into it, but
it didn't work.

Make sure that you are binding the data returned to a repeating control
otherwise only the first record will be displayed.

 

[bbsoftware]

Thanks for replying so quickly. I tried it again and it worked, it did
return more than the one record. I seem to be having trouble with some of
the sections with conditional formatting that I cut and past into my
repeating section. It says "data fields control cannot repeat here" Is
there a way to get my nested section to behave like it did outside the
section. I think it is that I bound the controls for the repeating section
to the whole table (there is only one table) and bound the controls for the
section with the conditional formatting to the same table. However I don't
see any other options, can I bind a section with multiple controls to one
field?