Lookup wizard help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have many differnent cells that pull from other tables, throught the lookup wizard. But when you go to run a querie it is only looking for the autonumber, or whatever number is assigned to the particular filed. Is there a way to have the querie look in the second column then in the first one. Second is there a wizard or help file that can help with creating a form for the report side. I want the database to ask for several different criterias by using check boxes etc and then pulling the form up without having to create long queries. If you are able to help thanks.
 
From your description, I will guess that you've created tables with some
fields that have the "lookup" data-type. If you look in such a table, what
you see in the field is the "looked up" value -- but what is actually stored
in the field is the underlying key value. This would help explain why your
queries require the key/?Autonumber.

A scan through the "tablesdbdesign" newsgroup and a visit to the MVPS.org
website will reveal a strong consensus AGAINST using lookup data-type
fields, for, among other reasons, what you've described!

The solution is to go back to those tables and change the data type to
LongInt (if the looked up table uses an Autonumber primary key), then do you
"looking up" in forms. Besides, you really need to be working in forms, not
directly in the tables!

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top