View Single Post
  #7  
Old January 22nd, 2008, 11:01 PM posted to comp.databases.ms-access,comp.databases.theory,microsoft.public.access,microsoft.public.access.tablesdbdesign,microsoft.public.sqlserver
Phil Stanton
external usenet poster
 
Posts: 17
Default Separate PK in Jxn Tbl?

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" wrote in message
news
"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