[AccessD] Access and SQL Server

Hi Stuart --

<<< 
 Jim's already stipulated that it's a many to many table.  It already allows
for multiple authors.
>>>
Sorry, I have missed that.
But anyway it doesn't make inapplicable my comment on using [LinkID] and
"consistent data design", does it?

Thank you.

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: 2 ????? 2011 ?. 12:36
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access and SQL Server

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.