InfoPath Dev

It's sql - talking to a view in the database. Hitting 'modify table' on the connection I get three drop downs for sorting the data.  There's nothing I can see there for 'multiple rows'.  Am I looking in the wrong place?

My secondary data source uses a query that will return either one row or no data.  However the data source fields appear to be created within a repeating group.  When these are dragged onto the form to create controls the controls are within a repeating section.  Controls outside of a repeating section cannot be bound to these ...

I've realised it is happening because I've got the controls within a Repeating Section.  At the time I created the template it seemed I had to put all the controls and fields within a repeating area to get them to bind correctly.  I'm only ever expecting one row (if data exists) but when no data is returned of course the ...

Yeah they are bound to a secondary data connection.  Under properties for either the controls or the source fields the 'default' box is disabled, I can't change that.  I'm sure I had the form loading (with blank controls) when the data was empty before I'm wondering if something else has changed.

I have a datasource pulling a single row back from a view and some controls are populated with the fields on that datasource.  If the query returns zero rows from the view then my form appears to freeze after the static header and before the controls should appear.  I can't seem to set a default value on these fields/controls - is ...