Drop-down lists from db

R

Ray

Is it possible to create a drop-down list which is
populated from a table, using the Database Results
Wizard? I understand that it may need a little manual
tweaking to do this, but is it possible. What I'm
thinking of is the following:
I have a table with generally static data which would
provide a foreign key to another table, so when I'm
populating that table I would like to have a drop-down
with the static data for selection. Although I could use
this static data hard-coded into the Drop-down,
occasionally this data will change.
 
J

Jim Buyens

Yes.

On pages 2 and 3 of the wizard, specify the table and
fields that will supply the drop-down titles and values.

On page 4, under Choose Formatting Options For The Records
Returned By The Query, choose Dropdown List - One Record
Per Item. Then, specify the Display Values and Submit
Values you want.

The display value is usually a mnemonic, such as Employee
Name. The submit value is often a code, such as Employee
ID. The form handler will receive and process the submit
value.

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)
|/---------------------------------------------------
*----------------------------------------------------
 
R

Ray

Jim,
Thanks - I tried that, but with limited success. The
wizard seems to assume that I want the data that appears
in the drop down list to come from the same table.
However I want it to look in another table for this. For
example I have a table called Item and this has a foreign
key with Condition. When I am adding an Item, I want it
to refer to the Condition table for the possible values.

Ray
 
J

Jim Buyens

Right. So on page 2 of the wizard, you should specify the Item table
as your record source.

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)
|/---------------------------------------------------
*----------------------------------------------------
 
R

Ray

Yes, that's sorted it out, thanks.

Ray
-----Original Message-----
Right. So on page 2 of the wizard, you should specify the Item table
as your record source.

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)
|/---------------------------------------------------
*----------------------------------------------------

"Ray" <[email protected]> wrote in
.
Click to expand...
 
Top