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