I have a Sharepoint list of newsitems. For simplicity's sake let's say it has two columns: title and content. That data I load into my form through a dataconnection.
I want to use a repeating table so that you can easily generate a newsletter out of the newsitems, by selecting the news item title from a dropdown list. The repeating table has nice controls to insert, remove and order item, so I think this will be much more useful than our current aspx page that just generates a static list starting from a certain id number.
Here's what I did:
In a blank new form I create a repeating table. In the repeating table I create a dropdown list, that gets it values from the newsitem titles.
Now I want the repeating table to fetch the corresponding news item title and show inside the repeating table. I do that by simply dragging the newscontent field from the dataconnection into the repeating table. That creates a repeating section. The section has a rule to hide everthing that is not equal to the title selected from the dropdownlist. So it shows only the article content that belongs to the selected title.
This works nicely when you have one article, but it doesn't work on multiple because it doesn't accept a repeating section in a repeating table.
So to visualize what I want to end up with here's a rough seketch of the repeating table:
Header
newsitem title 1 (select from dropdown in this form)
newsitem content 1 (fetch corresponding content from data connection)
newsitem title 2 (select from dropdown in this form)
newsitem content 2 (fetch corresponding content from data connection)
...
[insert item]
Can it be done??