Robert L. Stewart
rl_stewart at highstream.net
Wed Jun 29 09:58:43 CDT 2005
I thought that was what I said. :-) At 12:00 PM 6/28/2005, you wrote: >Date: Mon, 27 Jun 2005 16:35:57 -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: <20050627203557.KNJH29052.ibm68aec.bellsouth.net at SUSANONE> >Content-Type: text/plain; charset="US-ASCII" > >I think I've decided on a simple "people" table -- with a mtm related table >that describes their role in any publication. Seems to make the most sense >at this point. > >Susan H. > >Or, you could add a table for related parties and carry their role in that >table. Then you can get all the co-authors and illustrators, reviewers, >etc. > >tblPublicationRelatedParty >PublicationRelatedPartyID >PublicationID >PartyID >RoleID