Db Results Wizard - using lookup tables?

J

John Garvey

I am using the DB Results and Interface wizards. What is the best way to
create a form when the table's field values, are integers and the user needs
to see a lookup table to make the selection? In my db the tblDues has these
fields:

DuesID (autonumber, primary key)
PropertyID (lookup from a list of 200 properties in tblProperties)
OwnerID (lookup from a list of 250 owners in tblOwners)
DuesDate
DuesAmt

How can I create the form to will allow the user to make the appropriate
selection?
 
J

John Garvey

Hmmm. I was afraid of that. Thanks for the reply.
--
Thank you,

John Garvey


Kathleen Anderson said:
I don't believe that lookup tables work with the Database Results Wizard -
at least I've never been able to get them to work.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Specifying record source in a form control based on selection in another control in same form 9
query parameters in db results wizard 2
Creating Lookup Fields with Microsoft Access 2003 4
Import tables have same fields 14
DB results comparison questions 2
Dropdown Box to select db results 2
Set up db to lookup and concatenate large amounts of text 1
How do I create a lookup wizard that prevents unlisted entries? 1

Top