searching for names - multiple names per record

My database needs to track several names (first and last) for each record.
My initial database had all the names (first/last) in the main table. In an
earlier request for help re: searching for lastnames, someone suggested that
I put all the names in a separate Names table with a nameType comboBox. Now
that I've modified my database to do that, I see that with that design I can
only have one name per record. (To enter names, I select nameType, and then
enter first/last names for that nameType. I have no way of entering/adding
the first/lastnames for the other nameTypes. Each record has 5 or 6
first/last names to track. If they are all in one Names table, as
suggested, I can only hold one nameType in each record.

Can someone please suggest another way to solve my problem?

TIA


.

Relevant Pages

  • Re: searching for names - multiple names per record
    ... Typically when you have multiple names on a single record, ... My initial database had all the names (first/last) in the main table. ... select nameType, and then enter first/last names for that nameType. ...
    (microsoft.public.access.gettingstarted)
  • Re: searching for names - multiple names per record
    ... Project C John Brown John Brown Mary Smith ... with the combination of Id and NameType as the Primary Key. ... My initial database had all the names (first/last) in the main ...
    (microsoft.public.access.gettingstarted)
  • Re: searching for names - multiple names per record
    ... Thanks, Doug, but I just don't get it. ... Have a single name table with an additional column of NameType. ... My initial database had all the names (first/last) in the main ...
    (microsoft.public.access.gettingstarted)
  • Re: searching for names - multiple names per record
    ... I don't think you should have a separate table for each name type. ... name" that I should have individual tables for each nameType? ... My initial database had all the names (first/last) in the main ...
    (microsoft.public.access.gettingstarted)
  • Re: searching for names - multiple names per record
    ... name" that I should have individual tables for each nameType? ... Typically when you have multiple names on a single record, ... My initial database had all the names (first/last) in the main ... Now that I've modified my database to do that, ...
    (microsoft.public.access.gettingstarted)