Db Results Wizard - using lookup tables?

[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?

 

[Kathleen Anderson]

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

 

[John Garvey]

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

John Garvey

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