I'm new to the forum and to using databases on FP2000. My goal is to incorporate a drop down menu containing 54 products from which the customer will select one. After they push the submit button I want to display to part numbers with pricing (already contained in my Excel database) on the same page where I can include 'order now' buttons. So on a single page I want the drop down, the part numbers displayed with pricing and the order now buttons. I have been through Spooky's complete list of articles and viewlets and feel comfortable with working with database but don't know how to connect the function of a drop-down choice with a readout from the database. Any help will be greatly appreciated.

Circesdad

1. Using Excel vs. Access / SQL Srvr
2. DRW DropDown creations
3. Results

Personally, I don't use Excel directly in ASP. I'd put the data into Access and (assuming you're using FrontPage and dynamic Access data) use the DRW to create your dropdowns. I believe its Step 4 of the DRW in FP2000. Select Drop Down List from the menu (defaults to Table I believe) and the Display field (and value field if applicable)you want to use.

Then I'd set the properties of the form created (by the DRW) and point it to itself. Then on the same page, build your result table (or however else your presenting it). However, you will be making 2 calls to the DB on the same page (which is not recommended). There probably is a much smoother method, however I believe this will work.

Using the DRW can be kinda' limiting as to formatting, calculating, etc. If you're comfortable editing code, you will probably want to look into putting the DRW code on a 'diet' (search for diet in this DB Forum).

[This message has been edited by rdouglass (edited 08-01-2001).]