• No replies
301 Posts

Pinned topic Optim Delete Request - not leaving related records if child row changed

‏2013-03-01T09:46:44Z |

I'm fairly new to Optim and I’m having an issue with the Optim delete using relationships.

I’ve run a small test archive over a small section of our database, consisting of a parent table driving a set of child tables. I've changed a record in a child table and run the delete with compare. I was expecting the changed record, the parent record and any subsequent child records of the parent to not be deleted, but only the changed record wasn’t deleted.

Have I missed a check box somewhere or something?

In the access definition, I’ve tried both options 1 and 2, blank and checked.

Any ideas?