1st Christian name, 2nd Christian name, etc. in the same lookup ta

  • Thread starter Thread starter Peter Stone
  • Start date Start date
P

Peter Stone

Access 2003 XP Pro

I'm building a database of musicians.

1. Should I have 1st Christian name, 2nd Christian name, 3rd Christian name,
etc. all in the same lookup table and join to the main table in a
many-to-many relationship? I could then define the order of the Christian
Names (1st, 2nd, 3rd, etc.) in the junction table.

2. Should I put Nicknames (e.g., Stevie, Joe, Fats) in the same lookup table
as the Christian names or in a separate table or doesn't it matter? Initial
analysis indicates very little crossover between Nicknames and Christian
names.

Thank you
 
Peter Stone said:
I'm building a database of musicians.
Click to expand...

You're getting too complicated.
1. Should I have 1st Christian name, 2nd Christian name, 3rd Christian name,
etc. all in the same lookup table and join to the main table in a
many-to-many relationship? I could then define the order of the Christian
Names (1st, 2nd, 3rd, etc.) in the junction table.
Click to expand...

Put those in one field. Last name in a separate field of course.
2. Should I put Nicknames (e.g., Stevie, Joe, Fats) in the same lookup table
as the Christian names or in a separate table or doesn't it matter? Initial
analysis indicates very little crossover between Nicknames and Christian
names.
Click to expand...

Put nicknames in another field.

When doing name searching use the Like operator (along with the *s or
%s) and search both the name and the nick name field.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top