StaRKeY
starkey at wanadoo.nl
Thu Jun 30 17:11:09 CDT 2005
Hi again, Stick to the subject(fieldnames)... So lastname only in lastname field, firstname could contain something like 'Susan (Sales)'. The middle part is rather part of your first name then your lastname since people tend to do a search on lastname and besides that your lastname is Harkins and NOT Sales Harkins!! However I am more curious about the why you handle three professional names?? Isn't it the same person in three different roles?:-P In a letter or report or whatever you'd use your real name Susan Harkins and then maybe followed by a referal like (Sales) or (Teaser) so in short any data entry person would only enter your name once and then add three roles to it... Who the shoe fits... BN, Eric Starkenburg -----Oorspronkelijk bericht----- Van: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] Namens Susan Harkins Verzonden: donderdag 23 juni 2005 16:00 Aan: 'Access Developers discussion and problem solving' Onderwerp: [AccessD] Normalizing issue How do you guys deal with people that use three or more names professionally? I do -- Susan Sales Harkins. Do you store the second name with the first or use three fields? The middle name really isn't a "middle" name. It's actually part of the last name, but the last name is the real last name -- so if you stored it with the last name, you'd have to depend on users to enter it correctly, as in Harkins, Sales -- which is a mistake before you even get started... And how do you write in the flexibility that handles 2 or 3 names? 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:11:09 avast! auteursrecht (c) 1988-2005 ALWIL Software.