>>FWIW you are keying on DATA ! Don't want to start a religious war here but my own 2 cents is nevernevernevernever key on data ( i.e. something the user sees and can change ) The PK would be better off being a guid or being system generated and the cust_no being a candidate key
>
>Hehe, "religious" seems to be a very appropriate word in this context.
>
>I too, prefer keys which are not visible to the user (at least, most of the time).
Except that in religious wars, you don't find out if you're right until you die! < s >.
Fortunately, in programming, we get to test (and reconsider) our premises with in a more (speedily) iterative fashion with smaller consequences < bg > I've often thought this is the reason why so many of my favorite programmers have strong backgrounds in philosphy and theology.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
