Re: the idea of unique primary keys to be a solution that hasoutlived its usefulness?

["Booth Martin" <Booth@xxxxxxxxxxxx>]

Sure. a master file of customer names and addresses. How many primary
addresses can there be? Perhaps not hundreds, but certainly there can easily
be a dozen. Even defining various kinds of addresses as differing record
types isn't enough of a differentiation. Some solution is needed that does
not rely on uniqueness.
 
Obviously that raises the question of "Well, then where do we mail the
invoice if there can be more than one invoice address?" Fair question. But
what do you do if there are seasonal addresses for the person? What if they
have a winter address and a summer address? Do you use their season as part
of the key, to create uniqueness? 
 
 
---------------------------------------------------------
Booth Martin http://www.MartinVT.com
Booth@xxxxxxxxxxxx
---------------------------------------------------------
 
-------Original Message-------
 
From: RPG programming on the AS400 / iSeries
Date: 11/17/03 13:46:45
To: RPG programming on the AS400 / iSeries
Subject: Re: the idea of unique primary keys to be a solution that
hasoutlived its usefulness?
 
I understand what you are saying, but can you give a business example of a
file that expanded like this?
 
Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin