Table lookup field displays as number in REPORT

[Greenwood]

Hi all (I'm a newbie here)
I have set up a main table which pulls down a list from a related table (a lookup field). When I set up a report based on the main table, it displays the auto number from the related table and not the associated name.

In attempt to make more sense I will provide the specific set up:
main table = addresses
related table = county
So in the main table column 'county' I can select from a list of pre-defined counties from the related table.
When I view these in the main table it will say, for example, Devon. However, when viewed in my report it will display '33'.
Would much appreciate any help as I'm new to Access!
Many thanks

 

[RV]

Don't use lookup fields.
Look here for the reason why:

http://www.mvps.org/access/lookupfields.htm

Base your report on a query.
Combine the two tables in your query, using a join on countyID.
In your query, include the column County from your counties table.

RV

 

[Greenwood]

Thank you

Thanks RV that's very helpful if a little disappointing that I only found this out now! Next time, must do better...
G

Don't use lookup fields.
Look here for the reason why:

http://www.mvps.org/access/lookupfields.htm

Base your report on a query.
Combine the two tables in your query, using a join on countyID.
In your query, include the column County from your counties table.

RV