auto fill?

[Kelsey]

I have a database of information about people in a program and I finally
managed to make a drop down menu for their last names in the Form but I want
the first names to automatically fill in after the last name is selected. Is
this possible and if so, how?? Thanks so much!

 

[Kelsey]

How will it know what the first name is to fill in? What happens when
you have myself and my brother, Joseph Meehan and Robert Meehan?

It only contains about 30 or 40 names that I need to manage and none of the
last names are the same.