lookup column

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

Guest

I have a query that pulls info from a look-up table, when I go to filter my query, rather than use the sate code like MO it is forcing me to use the number assigned to that record. How do I change that so I don't have to go look-up the number associated with that state? Thank you for any info you may provide.
 
Hi Gianna

ensure that you have the lookup table as well in the top half of the query
window, then drag the state field out of that table to the bottom half and
set your criteria on this field .. .this will then filter the records via
the join between the two tables (IYKWIM).

Regards
JulieD


Gianna said:
I have a query that pulls info from a look-up table, when I go to filter
Click to expand...
my query, rather than use the sate code like MO it is forcing me to use the
number assigned to that record. How do I change that so I don't have to go
look-up the number associated with that state? Thank you for any info you
may provide.
 
Gianna, this is a known problem with lookup tables created using Access'
wretched Lookup Wizard. It not only hides the actual content of the
table, as you've seen, but it also creates extra indexes, even on fields
that have already been indexed. The way to get around this is to avoid
using the Wizard & to create your "lookup" table manually, just as you
would any other database table. Join this table to your base table on
the correct field (let's assume state abbrev. in this case) in a query,
then create your form based *on the query.* Then in Form Design View,
go to Properties & set the RowSource property for your dropdown list to
the correct table and the BoundColumn property to the correct field
number you want diplayed in your dropdown list (Note:Access has this
weird 0-based system, so the first field/column in a table is number
"0", the second field is "1", and so on, moving left to right.)

Hope this helps,

LeAnne
 
Back
Top