Re: Separate PK in Jxn Tbl?
Date: Tue, 22 Jan 2008 22:01:31 -0000
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" <phil_at_stantonfamily.co.uk> 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.
Received on Tue Jan 22 2008 - 23:01:31 CET