Well first of all I am getting a Unique Index Violation. I have a primary index in their which is not allowing similiar entries but I thought UPDATE or DELETE and INSERT work around it. I mean to say is that either old records are removed and replaced or deleted and added, respectively.

Lets say, I have workcard number 110A3401 which has 1-2-many relations with a zone numbers: 100, 200, 300. Now that if I want to edit these zones and put in new ones which are available in desciption table then I juts click on them and add them to the other side of the list which has selected items. When I close this selection form these selected items are added to the view. When I press the 'SAVE' button TABLEUPDATE is issued and uniquness error is triggered. I want this because if I dont want any changes then I can just do TABLEREVERT and get rid of any changes and exit out to viewing mode where REQUERY will populate the view with old records.

Thanks for your reponses.