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

>Bhavbhuti,
>
>Add some sort of "No Selection" entry to the list with NULL as it's PK.
>
>>I have this form with a cbo. This cbo is allowed to remain empty. If the user moves forward without modifying then alls well.
>>
>>Now supposing the user makes a selection and then he doesn't want it, how can he undo his selection. This cbo is connected to a lookup master database, as soon as the selection is made the FK in this table is updated with the PK from the lookup master.
>>
>>Except reverting changes is there any solution. Please advise.