[AccessD] Access and SQL Server

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.





More information about the AccessD mailing list