Re: Separate PK in Jxn Tbl?
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Tue, 22 Jan 2008 18:01:13 -0400
Message-ID: <479667ab$0$4030$9a566e8b_at_news.aliant.net>
>
> 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
Date: Tue, 22 Jan 2008 18:01:13 -0400
Message-ID: <479667ab$0$4030$9a566e8b_at_news.aliant.net>
Roy Hann wrote:
> "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
Either way, you are a lush! ;) Received on Tue Jan 22 2008 - 23:01:13 CET