classic dropdown questioin

[mazdaman]

How do i make a dropdown box populated from a MS Access database.Ive searched the faqs etc but have not found an answer i can work with.

The first dropdown would show a straight list from a table

'Select CourseID, from Coureslist',

Making a selection in this box would then get the details from the following query

'SELECT Applications.*, Courselist.*, Coursetitles.*
FROM Coursetitles RIGHT JOIN (Courselist RIGHT JOIN Applications ON Courselist.CourseID = Applications.CourseID) ON Coursetitles.CourseCode = Courselist.CourseCode
WHERE Courselist.CourseID ='CID'

Courselist = course ID numbers
Coursetitles = titles of the course, has a unique ID containd in the table 'Courselist'
Applications = provids further title information linked to other table (ignore)

Thanks for your help

 

[HowardMarks]

The following code should draw out a drop down list populated with your course names. When used within a form, it will send the selected course ID to another page for you to pull out the relevant details. (I have guessed the 'Title' fieldname which may need changing)


SELECT * FROM (CourseList INNER JOIN Coursetitles ON CourseList.CourseID = CourseTitles.CourseCode) ORDER by CourseTitle.Title

%>
<select name="courses"><%
rs.Open strSQL, objCon, 3
If Not rs.EOF Then
Do Until rs.EOF

%><option value="<%=rs("CourseList.CourseID")%>"><%=rs("CourseTitles.Title")%></option><%

rs.MoveNext
Loop
End If
rs.CLose
%></select><%

Nick (Webmaster)

http://www.npfx.com

http://www.artswales.org

 

[Bullschmidt]

Not sure if this is what you're trying to do:

Classic ASP Design Tips - Dependent Listboxes

http://www.bullschmidt.com/devtip-dependentlistboxes.asp

J. Paul Schmidt, Freelance ASP Web Developer

http://www.Bullschmidt.com

Classic ASP Design Tips, ASP Web Database Sample (Freely Downloadable)