Using a listbox on a data entry page

[david7777777777]

How do you have a listbox, which is displaying items from table A, be used as part of a data entry page that is used to enter new records into table B?

Thanks.

 

[amitlohia]

<SELECT name=&quot;Item&quot;>
<% Do while not rs.EOF
Response.write &quot;<OPTION value=&quot; & Rs(Field1) & &quot;>&quot; & Rs(Field2) & &quot;</OPTION>
rs.movenext
loop %>
</select>

 

[MerlinB]

A list has a visible part, and an invisible 'value' part. Make the 'value' the code used to link the two tables.

This is very easy if you use the DTCs (design-time controls).

A list can be single select (the default) - similar to a combo. Or multi-select.

In either case, when the form is submitted, the Request buffer will include the list name followed by the selected value (or comma separated list of values).

So you could use this in an SQL update...
&quot;Update xTable Set aLinkCol = &quot; & Request.Form(&quot;alist&quot _
& &quot; Where .....

I hope you get the picture!

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)