Re: Separate PK in Jxn Tbl?
From: Roy Hann <specially_at_processed.almost.meat>
Date: Tue, 22 Jan 2008 21:02:07 -0000
Message-ID: <obednVDy8opSxAvanZ2dneKdnZydnZ2d@pipex.net>
> 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.
Date: Tue, 22 Jan 2008 21:02:07 -0000
Message-ID: <obednVDy8opSxAvanZ2dneKdnZydnZ2d@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 - 15:02:07 CST