>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).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
