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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How do I retrieve multiple fields from SQL?


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.

0 Replies


Level 5

Take a look at Stefan Cameron's site -

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

Good Luck



Level 3

Please attach your form here.


Varun Nohria


Level 2

Hi Carol.

Tried to follow Marks link but didn’t work.

Try this one.

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



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