Getting tried. Need help.

R

Ron

Hi Folks

Getting very tried of trying to figure out my problem. I have a address
table. I need this info in another table. When I tried the look up field it
only displays the Bussiness name and not the rest of the info. I have asked
the question before I have tried but can not get it to work. Can some one
please help. I am just starting to work with this.

The other table is a fill in the blanks for a question sheet.

Ron
 
J

John Vinson

Hi Folks

Getting very tried of trying to figure out my problem. I have a address
table. I need this info in another table. When I tried the look up field it
only displays the Bussiness name and not the rest of the info. I have asked
the question before I have tried but can not get it to work. Can some one
please help. I am just starting to work with this.

The other table is a fill in the blanks for a question sheet.

Ron
Click to expand...

Forget about Microsoft's misleading, all but useless so-called Lookup
Wizard.

Instead, create a Query joining your main table to the address table.
You can then see the fields from both tables together; the Query can
be used as the recordsource for a Form or a Report, or pretty much
anything you can do with a Table. It is neither necessary nor wise to
copy the address data into another table.

John W. Vinson[MVP]
 
R

Ron

Sounds like that is what I want. But the one table has info that relates to
the Business. Can you explain how to make the Query. That will store the
address and the other info.

Ron
 
J

John Vinson

Sounds like that is what I want. But the one table has info that relates to
the Business. Can you explain how to make the Query. That will store the
address and the other info.
Click to expand...

Given that you have not described the content of your tables, nor how
they are related, no, I cannot. My telepathy is on the blink this
afternoon...

Could you describe your tables, their Primary Keys, and their
relationships, if any?

John W. Vinson[MVP]
 
Top