I've only been working with InfoPath and MOSS for a couple weeks now and have run into a problem I haven't been able to solve. I am creating a dashboard form - basically a form that will show an overview of all projects that have been created using another form and submitted to a SharePoint library. The problem is, when the user submits the first form I have repeating tables in order to facilitate a one to many relationship, and I submit this data using the merge column function. When I try to extract that data from the library into my dashboard form, InfoPath parses it into a single string with each value separated by a space.
Is there anyone to separate these values so each one will have its own separate row? I've done a lot of reading and seen things about the eval function and a lot of other stuff, but nothing concrete. Let me know if this isn't enough information.
Thanks for any help!