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.
--
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] =
::Position::

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.

"Steve" <(E-Mail Removed)> wrote in message
news:C2FF3DCF-B7D7-45CB-996D-(E-Mail Removed)...
> 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.
> --
> Thank you for your assistance

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


"Andrew Murray" wrote:

> 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] =
> ::Position::
>
> 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.
>
> "Steve" <(E-Mail Removed)> wrote in message
> news:C2FF3DCF-B7D7-45CB-996D-(E-Mail Removed)...
> > 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.
> > --
> > Thank you for your assistance
>
>
>

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


"Steve" <(E-Mail Removed)> wrote in message
news:C2FF3DCF-B7D7-45CB-996D-(E-Mail Removed)...
> 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.
> --
> Thank you for your assistance

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

--

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




"Steve" <(E-Mail Removed)> wrote in message
news:C2FF3DCF-B7D7-45CB-996D-(E-Mail Removed)...
> 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.
> --
> Thank you for your assistance

Hi Kathleen,

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

Kind regards
--
Thank you for your assistance


"Kathleen Anderson [MVP - FrontPage]" wrote:

> Hi Steve:
> I think this may help: How to filter a database query using two drop down
> lists.... http://www.spiderwebwoman.com/tutori...ledropdown.htm
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
> FrontPage Support: http://www.frontpagemvps.com/
>
>
>
>
> "Steve" <(E-Mail Removed)> wrote in message
> news:C2FF3DCF-B7D7-45CB-996D-(E-Mail Removed)...
> > 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.
> > --
> > Thank you for your assistance
>
>
>