Hi David, troubling you more. I have just posted a thread on validations using tables for critical analysis, just in case if you are interested could you kindly look at it and suggest.

Thanks.

>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>.