Good afternoon,
I am trying to develop a form that can pull data from a SQL Server secondary data source to populate a Client Info section (Client ID, Name, Phone, etc...) and then from there have a their order appear in a Repeating Table.
The client section will currently populate with only the first row of information in SQL. When I try to query for a different record no records appear. I have been able to get the repeating table to filter the data to show only the individual client's order but do not know if this is causing a problem with the client section.
I have read this post (http://www.infopathdev.com/forums/t/8421.aspx?PageIndex=1) but the methods here do not seem to work with SQL only Access and Sharepoint.
Any help would be greatly appreciated.
Thanks