connecting combo boxes to yield data in another cell.
 

I've created multiple combo boxes w/out a problem, but is it possible to have
a user choose a selection from one combo box, and then have it automatically
fill in the second combo box?
Basically, I'm trying to have a group of numbers in "combo box A", once
selected by a user, to default to a list of names in "combo box B".

For example, User selects "1" from combo box list, and then combo box 2
defaults to name "John"...