InfoPath Dev

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. for all the users in the my two lists. I've made the data connections to both lists and am using repeating table but can only get the data to display in the following way: Bruce Wayne Training Module 1 08/09/12 Bruce Wayne Training Module 2 08/09/12 Richard Grayson Training Module 1 09/15/12 Richard Grayson Training Module 2 09/20/12 Any help would be much appreciated. Thanks

Sounds like you need some nested repeating sections for this.  Basically you have a repeating section/table for list 1 with all the users.  Then create another repeating section/table inside the first one that will iterate through list 2 with all the entries.  This way you'll have all the entries displayed for the current user for that instance.  All you need to do is now to filter or query the entries table based on the user for that row.

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 applying the filter to the repeating control of list 2. Any further insights you have will be much appreciated.

That's an interesting problem, but it makes sense that it would do that.  Its one set of data, so applying the filter will apply to the entire set instead just that one instance per row.  A simple solution would be to limit the viewing capability to one person at a time, so that the list 2 entries will only filter based on the list 1 selection.  However, this wouldn't work if you needed to see all the persons at the same time.  You could use multiple data connections for list 2, but that wouldn't scale and you probably don't know how many list 1 persons there are.

Sounds like a difficult problem to come up with a solution for.  I'll let you know if I think of another solution for you to try.

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,