MS Access Help

[craig99]

Just new to access and trying to create and ASP page.

I have a table with 5 fields;ID, Catagory, Barcode, Description & Price.

I want to have a drop down box showing description & price, however the wizard only shows 1 field even though I have specified it to show 2. How to you do it?

Or an alternative ; a drop down showing description only, then another box on the screen showing the price of the item selected.

Can anybody help?

Cheers

Craig

[graham.edmon]

Since you're talking ASP I am assuming that you are doing this with a WEB based front end, yes?

solutions:-

1. concatenate the two fields together with non breaking spaces, setting the width long enough to hold both fields..

i.e.

   <select name="mydropdown">

   <%
     do until oRS.EOF
         response.write "<option value=""" & ors("value") & """>" & oRS("name") & "&nbsp;&nbsp;" & ors("Price") & "</option>"
         oRS.MoveNext
     loop
   %>
   </select> 

alternatively, you could built a java script array to hold the other information and on the OnChange event of the select box, you could populate a DIV tag with the relevant information.. (let me know if you want help on this un...)