lookup field

[Bonzai]

I have a problem with lookup that when i try to insert
FirstName, LastName, phonework and faxno(all different
field)from a query(from contact) into a form only the
firstname show.

Is there a way that when for the lookup that
automatically fill the Firstname, lastname phonework and
fax no in my client form.

any help would be appreciate

bonsai

 

[Duane Hookom]

Are you attempting to store the same information in more than one table?
Usually you want to only store the primary key from the related table. You
can easily create a combo box that has all the information in columns and
then "display" the information on your form. If you are using lookup fields,
you might want to read what many of us think about the mis-feature at
http://www.mvps.org/access/lookupfields.htm