Table only pulls 1st row from SQL database?

[Former Community Member]

Hi,

I have created a table in Livecycle Designer ES that pulls in data from a SQL Server table with 2 rows, see table.gif attached..

It only ever pulls in the first row and doesn't repeat for all rows in the SQL table.

How can this be done?

Thank you for your time,

Ollie.