>Many English and some Americans have four names. I have always wondered where they put them in databases. Maybe they squeeze both middle names into the middle name field.
>I read in a tourist guide to Mexico that Mexicans who have three names use the middle name as a surname. That must be why your third name field is called "Second Name". The book was explaining that if someone mailed a package to a Mexican post office addressed to an American tourist named Michael Edward Smith, they might file it under Edward, not Smith, and Mr. Smith would not find it unless he knew to look under "E". And, I guess, Carlos Salinas de Gotari would be "Mr. Salinas" or "Mr. Salinas de Gotari". Maybe that would not affect your table structure, but it could affect your interface. An American might enter Salinas in the middle name field and Gotari in the last name field. The database would generate correspondence saying "Dear Mr. Gotari:". Or he might put all of "Salinas de Gotari" in the last name field.

---

Names. Yes. Most systems I have seen only have First, Last and a middle initial for names. And for real I think only having room for 20 characters as a last name isn't enough. With huge Gb drives now of days, go ahead and make room.

And now where we are at it.. Don't forget to allow hyphen! :) I couldn't have it on my American drivers license, because their database didn't support it.