Problem creating multiple forms

[maineak99]

I would like to be able to generate a pre-filled form from a database.

The problem I am having is getting all the rows from the table when necessary.  When there are multiple rows I am only able to fill and print a single page .PDF form with the first row returned. I would like to have all the rows in the .PDF form for printing.

In other words, if there are 3 rows in my table I would like to generate one .PDF file containing 3 pages and be able to print all the pages in the file.

I am using an SQL Server database and Adobe LiveCycle Designer 8.0 and ASP.NET 2.0

Can this be done with the software I am using?

Or is there additional software I need?

I have been looking for this answer for quite some time, so any help is greatly appreciated.

Thanks in advance,

maineak99

[Hillyman]

I have been working on a similar issue, and in my research I came across these sources that might help you out:

Stefan Cameron is a great source of information, but you have to get used to navigating his site.  Categories can be selected on the left, and older articles in any category can be browsed by selected "Previous Articles" on the bottom left of each page.

http://forms.stefcameron.com/

This link may target your issues a little more closely:

http://forms.stefcameron.com/2006/10/12/displaying-all-records-from-an-odbc-data-connection/

The LiveCycle Developer Center seems to be a good resource as well.  Check out the section in this link title "Working with Data Sources and Schemas:"

http://www.adobe.com/devnet/livecycle/designer_scripting_samples.html

Hope some of those links get you started.