Robert L. Stewart
rl_stewart at highstream.net
Thu Jun 23 12:15:23 CDT 2005
Susan, tblParty PartyID tblPartyAlias PartyAliasID PartyID Company_Last_Name Middle_Name First_Name Name_Suffix Robert At 11:36 AM 6/23/2005, you wrote: >Date: Thu, 23 Jun 2005 09:59:59 -0400 >From: "Susan Harkins" <ssharkins at bellsouth.net> >Subject: [AccessD] Normalizing issue >To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> >Message-ID: <20050623135959.FMWJ25470.ibm57aec.bellsouth.net at SUSANONE> >Content-Type: text/plain; charset="us-ascii" > >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.