Drop Down Choices

[Guest]

Is it possible to have a list in a drop down box from a database function so
that when a choice is made that choice then no longer appears in the list for
the drop down box?

Ex:
Person One
Person two
Person three

I choose Person two.... now in the drop down box you would have...

Person One
Person three

-------person two is no longer there.

?????
Thanks,
Rlittle

 

[Thomas A. Rowe]

Not really, since the database query the populate the dropdown is not aware that an option has been
selected.

Even if you wrote a update query to mark the option as used, what about the next person using the
dropdown or when the list is empty, because all item are marked as used?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Peter R. Fletcher]

You could presumably do it on a per user (by cookie) basis in JS or
PHP.

Not really, since the database query the populate the dropdown is not aware that an option has been
selected.

Even if you wrote a update query to mark the option as used, what about the next person using the
dropdown or when the list is empty, because all item are marked as used?

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher