Re: Separate PK in Jxn Tbl?

From: Phil Stanton <>
Date: Tue, 22 Jan 2008 22:01:31 -0000
Message-ID: <>

Does a bottle of Gin have a serial no? I am too poor to buy 2 at a time to see if there is a different number Ah!


"Roy Hann" <specially_at_processed.almost.meat> wrote in message
> "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
>> BorrowerID.
> 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
Received on Tue Jan 22 2008 - 23:01:31 CET

Original text of this message