auto fill?

[Guest]

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!

 

[Joseph Meehan]

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!

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?

 

[Guest]

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.

 

[Joseph Meehan]

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

Unless you know 100% that you will not be adding names or reusing the
database later, I strongly suggest you start now by planning for that
problem. I happens time and time again that someone does a lot of work on
a project only to find that there is this little change than means the whole
thing needs to be re-done because of just this kind of issue.

In any case beat of luck.

 

[Joseph Meehan]

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

OK, I forgot to continue. Where exactly does it need to show up? In
the form displayed, in a report etc. ??