InfoPath Dev

Hi Hilary and Jo I have tried the BDC connection this but I think the problem is that I have too many records in my database, the SharePoint list does not render. When I try to connect directly to the database I have the following error: The amount of data that was returned by a data connection has exceeded the maximum limit that was ...

I am getting an error on my data because it looks like I am loading records. My SQL database is a secondary data connection there are no query fields, so I am filtering on the field. All works well ( a little slow) in preview but when I publish to sharepoint I get an error. Is there a workaround. I do not write code so looking for a solution ...

Yes that is exactly what I'm talking about I can connect to my database and table but I want to send a parameter and get one record out without the form loading all the records I'll put a post out see if anyone can help.

I am connecting to a single sql database but I cannot pass a parameter to the database - I'd like to query the database but there are no query fields.

Hi Steve I'm trying to do exactly the thing as you did but cannot figure out how to query my SQL database can you please tell me how you managed to connect to query your database? Thanks, Brenda

The problem listed in this post http://www.infopathdev.com/forums/p/13425/47634.aspx seems similar to the one I'm trying to solve but I don't know how to implement this solution using the repeated/nested tables. If anyone has any ideas how to resolve please let me know. Thanks,

Hi Anson, Thank you so much for your answer. I have tried exactly that solution - however when I set a filter - username from list 1 does not equal username from list 2 hide this control - it does not work - the list either displays all the entries or none. It doesn't seem to recognize that the user as a query/filter for the second list. I am ...

I have two lists - a list of users and a list of entries(training modules the user has completed) for each user . I would like to display this data in my InfoPath form in the following way: Bruce Wayne Training Module 1 08/09/12 Training Module 2 09/09/12 Richard Grayson Training Module 1 09/15/12 Training Module 3 09/20/15 etc. ...