Database drop down menus

[Guest]

Can someone please help me with my database? I manage a small recruitment
firm and I'm trying to setup two search drop down boxes (positions sought &
industry, using DRW in FP2003 & MS Access), when clicked, clients will be
transferred to an expanded database which is specific to their original
search.

 

[Andrew Murray]

You'll need the two drop down boxes
one with Position

eg Administration
Accountant
Programmer
Analyst
Web Designer
Graphic Designer

and in the "Industry" drop down box you'd have

Banks/Finance Sector
Government
Software Development
Private Sector

etc

Then your query would be

Select * from table JOBS where [Industry] = ::Industry:: AND [Position] =
:osition::

or similar.


You don't explain what sort of help you need i.e constructing the query or
the actual search form.

all you'd need are the two drop down boxes with the names "Industry" and
"Position" and list all the jobs/industriesdata within them

Unless you plan to populate those boxes from a database in its own right
rather than manually typing in each item, this is simple matter of producing
two database results areas, and displaying the results using the dropdown
boxes which become the basis for your search form.

Others here might be able to elaborate.

 

[Guest]

Hi Andrew,

Thank you so much for your prompt response. Where would I write this
script? I have also created a separate database (on a new page) where I want
the clients to be transferred to. The search database is in I'm wanting the
search results.asp, while the expanded database is in details.asp; so how
would I express this?
--
Thank you for your assistance

You'll need the two drop down boxes
one with Position

eg Administration
Accountant
Programmer
Analyst
Web Designer
Graphic Designer

and in the "Industry" drop down box you'd have

Banks/Finance Sector
Government
Software Development
Private Sector

etc

Then your query would be

Select * from table JOBS where [Industry] = ::Industry:: AND [Position] =
:osition::

or similar.


You don't explain what sort of help you need i.e constructing the query or
the actual search form.

all you'd need are the two drop down boxes with the names "Industry" and
"Position" and list all the jobs/industriesdata within them

Unless you plan to populate those boxes from a database in its own right
rather than manually typing in each item, this is simple matter of producing
two database results areas, and displaying the results using the dropdown
boxes which become the basis for your search form.

Others here might be able to elaborate.

Can someone please help me with my database? I manage a small recruitment
firm and I'm trying to setup two search drop down boxes (positions sought
&
industry, using DRW in FP2003 & MS Access), when clicked, clients will be
transferred to an expanded database which is specific to their original
search.

 

[Paul C]

Hi
I usually create a search using the DWR, this will create a text box to
enter criteria to search
Then create a drop down box (Insert- form -drop down box) outside of the DRW
region or on another page if you wish.
Delete the text box you wish to replace with the dropdown, cut and past the
dropdown (no form just the Dropdown) in place of the text box.
In the form field properties name the dropdown with the same name as the
deleted text box.you should now be able to search by selecting from the drop
down
Best wishes
Paul M

 

[Kathleen Anderson [MVP - FrontPage]]

Hi Steve:
I think this may help: How to filter a database query using two drop down
lists.... http://www.spiderwebwoman.com/tutorials/doubledropdown.htm

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/

 

[Guest]

Hi Kathleen,

Thanks for that link; database works great now! Thank you also Paul and
Andrew for your suggestions.

Kind regards