5 Replies Latest reply on Jan 27, 2011 9:03 AM by jsuber-tchd

    How to return records from an MS SQL Database


      I have created a small form in Adobe LiveCycle 9.  I setup a new data connection to a database on my MS SQL server 2008.  I can see my sql data fields under the data connection tab and bound them to my corresponding fields in my form.  The form populates with information from the first record in my database.

      I would like to create a field on my form where my users could enter in an account number and then my fields would populate from that record.  Right now I can only see the record with account number 1.

      Any help would be appreciated.