Stuart McLachlan
stuart at lexacorp.com.pg
Wed Mar 2 03:35:34 CST 2011
Jim's already stipulated that it's a many to many table. It alreay allows for multiple authors. -- Stuart On 2 Mar 2011 at 11:13, Shamil Salakhetdinov wrote: ... > > Your customer might also decide (one fine day) that having just one > author for a book isn't a "good idea" and that introduction of several > authors for a book is a "simple change request"... > > Thank you. > > -- > Shamil > ... >> >> So on a many to many linking table you would do this: >> >> tblBooksAndAuthors >> LinkID - Autonumber - PK >> AuthorID - Long - FK to tblAuthors - CK-A BookID - Long - FK to ?> tblBooks - CK-B >> >> And not simply: >> >> tblBooksAndAuthors >> AuthorID - Long - FK to tblAuthors - PK-A BookID - Long - FK to >> tblBooks - PK-B >> >> and eliminate an index? If so, why not? >> >> Jim.