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.