Expression Web Dropdown List to Access DB Challenges

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Expression Web Dropdown List to Access DB Challenges

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> Expression Web Help >> Expression Web Dropdown List to Access DB Challenges

Page: [1]


probe3000 Posts: 4 Joined: 1/23/2008 Status: offline	Expression Web Dropdown List to Access DB Challenges - 1/23/2008 17:48:54 Hello, I’m in the process of creating an Expression Web application. The last remaining challenge for a form that I’m creating is the format in which it saves to the Access database. I choose an “Agency” from the dropdown which comes from an Access table. I then want that table to post its results to my primary table called “Personnel”. (see item "1" on the picture) The problem is that when everything is entered and “Insert” is clicked, I receive the following in the DB. (see item "2" on the picture) As you can see from above, the “Agency” columb shows the # “1” rather than “Fort Collins PD” (see item "3" on the picture) Here is a snip from the “Agency” table where the data is coming from. I've purchased four books which have been very helpful but none have spent very much time if any on the subject. Hint hint Thanks for your help! Frank Thumbnail Image Attachment (1)


dpf Posts: 7126 Joined: 11/12/2003 From: India-napolis Status: offline	RE: Expression Web Dropdown List to Access DB Challenges - 1/23/2008 17:58:26 is 1, the position of Fort Collins in your table? _____________________________ Dan (in reply to probe3000)


probe3000 Posts: 4 Joined: 1/23/2008 Status: offline	RE: Expression Web Dropdown List to Access DB Challenges - 1/24/2008 0:06:02 Hi Dan, Its hard to tell. If you look at my picture, the web page starts with "Loveland PD" but the DB table starts w/ "Fort Collins PD". Frank (in reply to dpf)


probe3000 Posts: 4 Joined: 1/23/2008 Status: offline	RE: Expression Web Dropdown List to Access DB Challenges - 1/24/2008 12:46:18 Here are some more settings: Under Databindings for the dropdown list, I have SelectIndex Field Bindings - Agency (field) in my Personnel table No formatting Using Two-way databinding Here is a picture of my MS Access settings. Thanks! Thumbnail Image Attachment (1) (in reply to probe3000)