Query a database by DRW

[Mike]

I have a database in my site. It has a table with 2
columns I wish to search by. Once is called "number" and
the other is called "project".

Using the DRW, how can I create 2 form fields on the
homepage so the user can decide how they wish to search
by.

Thanks in advance.

-M

 

[Jim Buyens]

On page 3 of the wizard, click More Options, Criteria, Add.

Then, in the Add Criteria dialog box, select the first
field you want to query by, select Use This Search Form
Field, and click OK.

Then click Add a second time, select the second field you
want to query by, select Use This Search Form Field, and
click OK.

Click OK, OK, Next, Next to get to page 5 of the Wizard.
Then select Add Search Form and click Finish.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Mike]

Jim,

Thanks, that worked. I have an adder to this. Can I have
another search field that is made up of a drop-down list
of the actual project names? so the users if they choose,
can select the exact project name?

-M

 

[Jim Buyens]

Yes, but for that you must:

o Deselect Add Search Form on the last page of the wizard.
o Create you own HTML form, enclosing the entire page.
o Add a text box for the first search field. Be sure to name
it the same as the field it will filter.
o Set the insertion point inside the form but outside the
existing Database Results Region, then choose Insert,
Database, Results.
o On pages 1, 2, and 3, specify the database table that
contains the project names and projects codes.
o On page four of the wizard:
- Select Dropdown List, One Record Per Item.
- In the Display Values From This Field drop down list,
select the field that contains the project name.
- In the Submit Values From This Field drop down list,
select the field that you want to use as a criterion
in the main Database Results Region.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------