Populating Combo Box from Lookup table

[Syerston]

I'm new to the world of asp so please bear with me.

What I'm doing is populating a combo box with two columns, a period and an ID. The combo box will display the period but store the ID in the tenant table. THIS PART I'VE MANAGED TO DO.

<select name=&quot;cboName&quot; size=&quot;1&quot;>
<%
Do While Not objRS.EOF
%>

<option VALUE=&quot;<%=objRS(&quot;ID&quot%>&quot;>
<%=objRS(&quot;Desc&quot%></option>
<%
objRS.MoveNext
Loop

%>
</SELECT>

My problem is I then want the application to populate another combo box on an update page with the period lookup values and ID's but set the current value and ID to what is stored in the tenant table.

 

[mumbojumbo]

Do you mean on selection of this combo it populates another?

<sub><img src=

http://www.pleasuretoy.co.uk/temp/alf2.gif></sub>

 

[guitardave78]

pleasuretoy.co.uk????????

 

[Syerston]

No thats not it.

The record has been saved from the first page. When the user goes into the update page the combo box that will contain the period will be populate with the choices from the period look up table (to allow the user to change what was previously saved), but of course the combo box will have its value set to the period id that was previously saved.