Re: Separate PK in Jxn Tbl?

From: Phil Stanton <phil_at_stantonfamily.co.uk>
Date: Tue, 22 Jan 2008 22:01:31 -0000
Message-ID: <13pcptphap2o46a_at_corp.supernews.com>


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!

Phil

"Roy Hann" <specially_at_processed.almost.meat> wrote in message news:obednVDy8opSxAvanZ2dneKdnZydnZ2d_at_pipex.net...
> "Phil Stanton" <phil_at_stantonfamily.co.uk> wrote in message
> news:13pclc9bkkveq4e_at_corp.supernews.com...
>>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