Multiple data in one field

[Guest]

I want to use lookup for our Customer Name. However, when we select a
Customer I want to also select the address. Is this possible?
Thanks!

 

[John Vinson]

I want to use lookup for our Customer Name. However, when we select a
Customer I want to also select the address. Is this possible?
Thanks!

That's not how relational databases work. You certainly do NOT want to
store a name and an address in one field!

If you're using Microsoft's misleading, misdesigned, and all but
useless so-called Lookup Field type, DON'T. See

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

for a critique.

Instead, use a Form based on your Customer table. Display whichever
fields you want to see - name, address, etc.

Then use the Combo Box Wizard to create a Combo Box on the form;
choose the option "Find a record". It will give you an unbound combo
which will move the "window" of the form to the desired record in your
table.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps