displaying lookup fields

[Guest]

Can anyone help.
I have created two tables customers and booking. From the booking table I
have created a form for entering the booking information. For the customer
field within this form I have used lookup columns from my customer table. In
the booking form I click on the customer field and it correctly shows list
of customers. I select the correct customer but the field only displays the
first name. Is there a way I can select the customer and the filed to display
both the first name and last name, address and postcode?

I am desparate can you help?

 

[ruralguy via AccessMonster.com]

Firstly, I hope you are not using LookupFields in your tables.
http://www.mvps.org/access/lookupfields.htm

Second, all you need in your booking table is the CustomerID (PrimaryKey)
from the Customers table which is hopefully an AutoNumber. Put this key in
the booking table as a ForeignKey (Long) and then a query that joins the two
tables can show as many of the Customer fields as you want.

 

[Guest]

Thanks for your reply.

I am getting there slowly. I have done as you suggested. When I add an
existing field such as the customer ID, Access disply a look up column field
requesting further information. To clarify I am not select "Look up column"
Is this acceptable.
I have not gone to the query part yet.

So I clearly understand your reply, if I create the query when I enter the
customer ID the other fields from the customer table will be auomaticaly
entered in the the fields in the booking form. (as long as they are part of
the query)

What I would like to do from here on is create a booking form using an
existing customer. Is there a way I can create a form that allows the user to
search customer details such as name, address etc and then be taken to the
booking form with the relevant customer information already inserted?

Just to be cheeky I have one more of many questions.
Related to my customer information is the dogs they own and the information
that relates to the dog (in a separate table). How can I create a button that
takes me to a dog information form that is blank. I have attempted to do this
but there have been errors. The form opens with an existing record and
secondly I cannot edit the information in the form.