I have data stored in a table, Surname, firstname, date of birth. What I
want to do is select the surname in the combobox I have done this part. I
then want to select the firstname from the associated data in the table, ie
three people sharing the same surname but different first names, so that
only those three names show not all the names I have in the list. this
should then be down to one name and the date of birth then populates the
third box. Can anyone help me out with this.