[AccessD] Re: Normalizing issue

Susan,

You can incorporate the first, middle, and last name model for the pen name 
also.  Actually, that was the way I had it in the first alias table that I 
sent out.  I compressed it in the last one.

And, LIKE "*TWAIN*" would find all instances of it.  Just easier if you are 
looking in the last name field.

Robert

At 01:28 PM 6/23/2005, you wrote:
>Date: Thu, 23 Jun 2005 13:55:45 -0400
>From: "Susan Harkins" <ssharkins at bellsouth.net>
>Subject: RE: [AccessD] Re: Normalizing issue
>To: "'Access Developers discussion and problem solving'"
>         <accessd at databaseadvisors.com>
>Message-ID: <20050623175546.WABL7767.ibm60aec.bellsouth.net at SUSANONE>
>Content-Type: text/plain;       charset="us-ascii"
>
>The edit it as needed for the special cases.  This model also incorporates
>an alias table to hold the solution to what Susan needs for her pen names.
>All she would need to do is add a table to relate the pen names to the
>publisher for the articles being published.
>
>===========The alias is all  one field though -- right? I don't think that
>would work for pen names as I can see a need for searching on pen name
>(think Twain) rather than member name -- and a search for Twain isn't going
>to work if the field is "Mark Twain"
>
>Susan H.