[AccessD] Normalizing issue

I use middle name.  My feeling is that no one cares if it's actually a last
name or middle name.  Either way it's in the right place all the time if you
use a middle name field.

The question really is how is that person listed on legal documents.  If,
for example, you are listed on your mortgage or social security (or
whatever) as Last name = Sales Harkins, First name = Susan then that's the
last name, but if you use it "unofficially" then I would make it a middle
name.

Reuben Cummings
GFC, LLC
phone: 812.523.1017
email: reuben at gfconsultants.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins
Sent: Thursday, June 23, 2005 9:46 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Normalizing issue


So you both depend on the data entry person to enter Harkins Sales instead
of Sales Harkins?

That's interesting. ;)

Susan H.

The number of records that have a second last name vs those that don't
dosen't warrant our efforts to program around it. We put the burden of
keying it in properly on the business/clerical departments.


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com