Getting tried. Need help.

[Guest]

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

 

[Lynn Trapp]

So you have the address of a business in one table and you want to store it
in another table? Is that correct? If so, let me suggest that that is a very
bad idea. Data should be stored in only one place and then queried when it
is needed.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[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

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]

 

[Guest]

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

 

[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.

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]