-----Original Message-----
I have followed the knowledge base article (278613) for
using multiple criteria with a drop down menu - but the
one item I want the value of is stored in a separate
table.
Any way to do this?
I'm not exactly sure what you mean by this. Do you want
one drop-down box to several records from one table plus
one record from another table?
If so, you would have to code a custom SQL statement that
combines the result of querying each table. This is
called a "union" and you need a database like SQL Server
or Oracle to do it. I don't believe Microsoft Access has
the capability.
Usually, when people get to this point, they decide
they've outgrown the Database Results Wizard and start
coding their own ASP or ASP.NET pages. The kind of thing
I believe you're describing is fairly easy if you write
your own code.
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*
