Posted by cover on 12/11/05 04:38

Is it possible to use a 'mouse up' click in forms where if you have
for example, a drop down menu where you might click as the top
selection, an equipment area (hard coded into the form), the type of
equipment (a selection of 3 items again hard coded into the form), and
then upon 'mouse up' of the second field (equipment type), have the
3rd pull down populated by the mouse up click of the second selection
showing database entries available based on the top two selections?

I have queries that allow for a selection of 'equipment area'
hardcoded into the form and results based on a particular query
showing up in the pull down below based on clicking a 'submit' button
but it would be pretty cool and convenient if I could select the
equipment area, type of equipment with the bottom pull down populated
with equipment within a given area, type, the particular equipment in
question AND THEN on 'submit' show all records for that particular
piece of equipment.

to anyone who may be familiar with what I'm trying to do, thanks very
much for any pointers.

Chris

[Back to original message]