Look-up Fields (I think!)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to enter a customers ID number on a form and then it automatically populate the First Name and Last name fields. All of these fields are contained within one table called 'customer details' for which there is a form designed to enter the details in. There is a relational table called appointments by the customer ID field. It is from this table I wish to enter the ID number and for it to display the First Name and Last name from the Customer Details table????

Hope this makes sense? Help please................
 
Use a combo box to select the ID. Then see The ACCESS Web for how to
populate the textboxes:
http://www.mvps.org/access/forms/frm0058.htm


--

Ken Snell
<MS ACCESS MVP>

Amanda Dale said:
I would like to enter a customers ID number on a form and then it
Click to expand...
automatically populate the First Name and Last name fields. All of these
fields are contained within one table called 'customer details' for which
there is a form designed to enter the details in. There is a relational
table called appointments by the customer ID field. It is from this table I
wish to enter the ID number and for it to display the First Name and Last
name from the Customer Details table????
 
Amanda,

Make your form based on a query, which includes both your Customer
Details table and the Appointments table, joined on the Customer ID
field. That way, you have the customer names directly available for you
to include on the form, and as soon as you enter the Customer ID for the
Appointment (probably by using a combobox), the names will automatically
display. If you use this method, you should set the Enabled property to
No and the Locked property to Yes for the customer name controls.
 
Back
Top