You'd better explain your precise need, but in general, you wouldn't put
multiple names on a single record.
Typically when you have multiple names on a single record, it means you've
got field names like "Originator", "Approver", "Developer" etc. That's not a
good idea: you're hiding data in the field names.
Instead, you should keep the common information in the one table, and create
a second table linked to that first table with one row for each name.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"zSplash" wrote in message
...
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 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