Bhavbhuti,

But you basically have this as a nullable column since it's optional right? If so an item with a null value as it's key is the easy thing to do.

>Thanks David for the reponse, but I use views non updatable (in my mind I have a feeling this may lead to less corruptions and more efficiencies). Putting such a record in the table by default will wreck havoc atleast to my thought processes <g>.