I'm using Impromptu to build a form letter. Everything so far has gone well, as I've built my filters and data.
The problem arose when I attempted to get multiple rows of data on the same page of a form letter. Of course, this seems like normal behavior, because normally for each piece of data (ie, name & address) you get back from the DB, you want a new letter.
However I have a section where for each name on the list, there could be 1-5 related 'rows' that should also show up in the letter. I get the data to come through, but for each of these rows, it just makes a new letter with the same address/name info, the only changing being these extra rows I'm trying to include. I'd like it to create only one letter, with a table of these 1-5 rows on the page.
Any ideas?
The problem arose when I attempted to get multiple rows of data on the same page of a form letter. Of course, this seems like normal behavior, because normally for each piece of data (ie, name & address) you get back from the DB, you want a new letter.
However I have a section where for each name on the list, there could be 1-5 related 'rows' that should also show up in the letter. I get the data to come through, but for each of these rows, it just makes a new letter with the same address/name info, the only changing being these extra rows I'm trying to include. I'd like it to create only one letter, with a table of these 1-5 rows on the page.
Any ideas?