Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

How do I retrieve multiple fields from SQL?

carolfaye
Level 1
Level 1

I am trying to retrieve multiple fields from a SQL table such as customer name, address and phone number by entering the customer # in my form either in a text field or a data drop down list.  I can get the drop downlist to populate from the table, however the other fields do not coorespond to my selection.  It appears that they are from the first record in the table regardless of which customer # I select from the drop down list.  Any assistance would be greatly appreciated.

4 Replies
Mark_Lindberg
Level 5
Level 5

Take a look at Stefan Cameron's site - http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/

Lots of good information for connecting forms to data sources and walking the results.

Good Luck

Mark

Varun_Nohria
Level 3
Level 3

Please attach your form here.

Regards,

Varun Nohria

Raffe
Level 2
Level 2

Hi Carol.

Tried to follow Marks link but didn’t work.

Try this one.

http://blogs.adobe.com/formbuilder/2006/09/selecting_specific_database_records.html

At the moment I am about to start on this process with my form, so if you have any tips , please pass them on.

Raffe.

carolfaye
Level 1
Level 1

Thank you so much! I am looking at it now.

Carol Faye

First Transit, Inc.

General Manager

NETSPAP Project Manager

799 Roosevelt Road

Building 4, Suite 200

Glen Ellyn, IL 60137

Phone: 630-873-1344

Fax: 630-873-1350