>The problem Vinod was having was caused because he used a foreign key instead. >When he deleted one record with a given foreign key value, all records with >that value were deleted.

right, it is just that from the way you phrased it - it sounded (at least to me) as if you are saying a view on a table without a PK will not be updatable


Arnon