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.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Please attach your form here.
Regards,
Varun Nohria
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies