James,

If I understand correctly, you are looking for a way to differentiate between the multitude of drop-down boxes you've created. You could try something like this:

FUNCTION Lastfunc
lcDropBox= [<p><select size="1" name="dbxSection_<%=alltrim(ssn)%>">]+;
[<option>A</option>]+;
[<option>B</option>]+;
[<option>C</option>]+;
[<option>SS</option>]+;
[</select></p>]

SELECT ssn, lastname, Firstname, mergetext(lcDropBox) as Section;
  FROM officers WHERE orgno=1421 INTO table temp
  SELECT temp

response.showcursor()

ENDFUNC
>

This will give you unique names for each drop-down based on the SSN. You can then get a list of the form variables submitted and scan them for names starting with dbxSection_. Grab the value and read off the SSN and you're away!

Cheers,

Andrew

>I am trying to figure out how to retrieve data from a showcursor where I am creating drop-down boxes in the showcursor(). IOW how do I update my table officers from the Drop-down selections made in the showcursor()?
>
>

>FUNCTION Lastfunc
>lcDropBox= [<p><select size="1" name="dbxSection">]+;
>[<option>A</option>]+;
>[<option>B</option>]+;
>[<option>C</option>]+;
>[<option>SS</option>]+;
>[</select></p>]
>
>SELECT ssn, lastname, Firstname, lcDropBox as Section;
>FROM officers WHERE orgno=1421 INTO table temp
>SELECT temp
>response.showcursor()
>
>ENDFUNC
>