Database Query

[Guest]

I have a database query setup through FP (insert, database, results) The
search function works great but I am wondering if it's possible to search
from a list of entries. Currently a person must type the person's name (and
hope it's spelled right) to search for information.
People's names are entered to the database through a form by a drop down
menu. I want to use the same idea when searching for information on that
specific person.

Thanks

 

[Guest]

Add a Database Results Wizard to the form, taking care on page 4 of the
wizard to specify Dropdown List - One Record Per Item. Also, set:

o Display Values From This Field to the field that you want the drop-down
list to display.

o Submit Values From This Field to the field that you want the Web server
receive (which might be the same as the Display Values ... selection,
or might be an record ID or whatever).

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| 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)
|/---------------------------------------------------
*----------------------------------------------------

 

[Guest]

Almost what i'm looking for. Actually on page 3 under more options i setup a
search criteria almost like a filter that will show me the info based on what
I put in there. that is where I would like the dropdown box to be, preset
with names as in a form dropdown box.

 

[Guest]

Right. You're going to set up two Database Results Regions: one to display
the drop-down list and one to display the query results.

In the second region, you treat the database-generated drop-down list just
like any other drop-down list. To get the form field name, right-click the
drop-down list (which will appear empty in Design view), choose Form Field
Properties, and observe the Name field.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| 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)
|/---------------------------------------------------
*----------------------------------------------------