Let me see if this makes sense, I have a Form Select populated from a small database. I'd like the pulldown list to include two items per line. Basically it's a number followed by what the number means.
Here's my SQL as hashed out by me (no laughing, I am not a programmer)
FROM heavybombers.Groups JOIN heavybombers.[Listbox-Grouptype]
ON GroupID = ID
ORDER BY GroupSort ASCThe two items I want in the pulldown list are "GroupNumber" and "Group_Type".....is this possible?
Here's my select code populated with "GroupNumber":
<option value="value">Group</option>
<%
While (NOT rsGroup.EOF)
%>
<option value="<%=(rsGroup.Fields.Item("GroupId").Value)%>">
<%=(rsGroup.Fields.Item("GroupNumber").Value)%></option>
<%
rsGroup.MoveNext()
Wend
If (rsGroup.CursorType > 0) Then
rsGroup.MoveFirst
Else
rsGroup.Requery
End If
%>
</select>This would usually be where I'd call my programmer and say, "HELP", but he's in the process of moving cross country.
Here's my SQL as hashed out by me (no laughing, I am not a programmer)
Code:
SELECT GroupId, GroupNumber, GroupSort, ID, Group_Type FROM heavybombers.Groups JOIN heavybombers.[Listbox-Grouptype]
ON GroupID = ID
ORDER BY GroupSort ASC
Here's my select code populated with "GroupNumber":
Code:
<select name="Group" id="Group"> <option value="value">Group</option>
<%
While (NOT rsGroup.EOF)
%>
<option value="<%=(rsGroup.Fields.Item("GroupId").Value)%>">
<%=(rsGroup.Fields.Item("GroupNumber").Value)%></option>
<%
rsGroup.MoveNext()
Wend
If (rsGroup.CursorType > 0) Then
rsGroup.MoveFirst
Else
rsGroup.Requery
End If
%>
</select>