Lookup Fields Show all Info

[Guest]

Lets try this again. I have a look up field for address table which I use in
another tabel. When the other report field has the info it only wants to
show the name and not the rest of the address info on the report. How do you
show the rest of the address information.

I am just learning the access I have done a few programs with access but
never had this problem

What I want is to merge the address info into other tables and reports with
out type them many times.

Please help

Ron

 

[John Vinson]

Lets try this again. I have a look up field for address table which I use in
another tabel. When the other report field has the info it only wants to
show the name and not the rest of the address info on the report. How do you
show the rest of the address information.

Create a Query joining the main table to the address table (i.e. don't
bother with Microsoft's misdesigned, misleading, and all but useless
so-called Lookup Field).

This Query will allow you to pick any or all of the fields from both
tables for inclusion upon the Report.

What I want is to merge the address info into other tables and reports with
out type them many times.

Of course. That's just what relational databases - and their most
basic, most powerful tool, the Query - are designed to do.


John W. Vinson[MVP]