Auto Look ups???

[Switchwork]

Hello I would like some information on how to go about creating a way of entering the ID number for ie a customer and there Name appearing in the field space on a form. Is this auto lookup and if so how do I do it.

Another thing I am not sure of is the filling out of my forms. If I have a customer ID and Employee ID do i really have to make lists of each customer ID so I can enter them into the form when I am entering data as I have over 300 customers and it is hard to keep track of all the IDS for the database. I don't know if i have been advised right regarding this but this is how I have been doing it for the past year.

Any suggestions would be appreciated.
Thank you
Switchwork.

AKA CLARE!!!!

 

[Kraj]

Well Clare, I've got a little help for you I think. As far as populating the forms based on the ID number, I don't know exactly how to do that but there are posts about it around. I'd search on the keywords "populating fields" and see what you can hit.

As far as entering the employee and customer IDs the answer is "yes and no". Here's what you do: on your form create a combo box. Base the box on the employee table and select the employee name fields. Leave the "Hide Key Column" box checked. Now on the form you will have a drop-down box that will display employee names. You can either scroll through or start typing and it will jump to the matching name in the box. When you find the correct name, the employee ID is what actually gets selected and stored by Access but you never have to see it.

Hope that helps.