[AccessD] Re: Normalizing issue

Susan,

tblPublication
PublicationID
PublicationType   (Book, Article, White Paper, etc.)
PublicationTitle
AuthorAliasID

Then you can add any other information appropriate for the publication, 
like InPrintFlag, CopyrightDate, PublisherID, etc.

Over design!!!!  You can always back off an over designed system.  It is 
much harder to fix an under designed system.

Robert

At 01:28 PM 6/23/2005, you wrote:
>Date: Thu, 23 Jun 2005 14:28:24 -0400
>From: "Susan Harkins" <ssharkins at bellsouth.net>
>Subject: RE: [AccessD] Normalizing issue
>To: "'Access Developers discussion and problem solving'"
>         <accessd at databaseadvisors.com>
>Message-ID: <20050623182824.MXAF11273.ibm67aec.bellsouth.net at SUSANONE>
>Content-Type: text/plain;       charset="us-ascii"
>
>This is really getting much more complicated than I had planned. Now I have
>to figure out how to deal with books versus articles. :) I thought about one
>table that id's each publication as a book, article, etc. but I have one
>problem.
>
>Books are usually in or out of print and that just doesn't apply for
>articles. If I use a Yes/No for InPrint, then I've got records when an
>inappropriate value -- No for magazines isn't really correct. I could use a
>tri-state Yes/No I guess, and put Null to work, but ug...
>
>I can have a separate table that stores only book InPrint field. Or, I can
>just use two different tables, one for books, for mags.
>
>Susan H.