StaRKeY
starkey at wanadoo.nl
Thu Jun 30 17:13:19 CDT 2005
Mmmzzzz still going strong this thread.... So writing names?? Use aliasses instead of roles like i mentioned in earlier mail... Whatever they want just give i to them and let them have as many names/aliasses/roles they want:-) -----Oorspronkelijk bericht----- Van: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] Namens Susan Harkins Verzonden: donderdag 23 juni 2005 17:43 Aan: 'Access Developers discussion and problem solving' Onderwerp: RE: [AccessD] Normalizing issue If it isn't a middle or maiden name, what is it? This gets even more tricky with non-English names where "last" names can get really confusing. I generally provide a field for first, middle, and last name and make it the responsibility of the user to enter the appropriate value in the appropriate field. The rules for parsing this can become so draconian, that it hardly seems worth the work to do anything else. ========I'm in the middle of creating a database (pro bono) for a writer's organization. It's a simple deal and will require little work -- but this is already cropping up. These people will want their "writing" names with their publications -- I'm thinking about just adding one more field to store their "pen name" or whatever -- but then that becomes a nuisance if their name and professional name are the same -- gotta fill in both or allow for the blanks and go find the real name -- such a nuisance -- I think at this point the middle name is the best solution -- Susan H. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _____ avast! Antivirus <http://www.avast.com> : Uitgaande bericht is niet besmet. Virus Gegevensbestand (VPS): 0526-3, 30-06-2005 Getest op: 1-7-2005 0:13:19 avast! auteursrecht (c) 1988-2005 ALWIL Software.