Lookup Tables and Report Output

  • Thread starter Thread starter assyrian47
  • Start date Start date
A

assyrian47

NEWBIE

I have a lookup table that is used to make data entry easy. The lookup
table consists of 8 entries. These are autonumerated from 1-8.

1 Label 1
2 Label 2
3 Label 3

etc.

When I try to make a report with this all i get is the numbers in the
field location. How do I get the field to contain the actual value?

thanks
 
Hi,
what do you mean with lookup table. Do you mean you are using lookup fields
in tables? This should be avoided for several reasons. You can read all about
the evils of lookup fields here:
http://www.mvps.org/access/lookupfields.htm
You should instead have a real lookup table and if you want to use a
combobox then do so on a form based on this lookup table. This way your data
should be displayed correctly.
HTH
Good luck
 
Back
Top