Re: Separate PK in Jxn Tbl?

From: Bob Badour <>
Date: Tue, 22 Jan 2008 18:01:13 -0400
Message-ID: <479667ab$0$4030$>

Roy Hann wrote:

> "Phil Stanton" <> wrote in message

>>I always use just the 2 primary keys but....
>>If I were a library lending 2 undiffentiatable copies of 1 book to the 
>>same person, I suppose I would need an Autonumber PK plus A BookID and 

> Hmm. Not persuaded. At best you have concealed a problem with the business
> process, at worst you have allowed the very same copy to be lent multiple
> times without detection.
> I say this with some passion, having come home to find my cash register
> receipt shows a single bottle of gin got scanned twice.
> Roy

 From that last anecdote, one can conclude one of two things: 1) gin was only a small part of the overal liquor purchase or 2) you were too drunk to notice.

Either way, you are a lush! ;) Received on Tue Jan 22 2008 - 23:01:13 CET

Original text of this message