Apologies for the wall of text - this was correctly formatted before I posted.
Using InfoPath & SharePoint 2010 I have a data connection in my browser based form which retrieves a SharePoint list.
The form is a online order form and the list is the full product/price list.
My form is set up to retrieve the data and then load ...