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
