W
Wolf
Hi
I built a form with a sub-form who took its records in a
table. That table have relations with others, with
cascading deletions.
The deletion of a record in that file was working fine,
you delete it, and it was also deleting the records in the
other tables.
I had a 'crash' on that form. when I was opening it, I was
having a 'Watson'. Compacting didn't change anything.
So, I created a new database, and I imported all the
objects in it. It works. Everything is running fine.
But I can't delete anymore records in the subform. If I do
it, I have the message : "Cannot perform cascading
operation. Since related records exist in table <name>,
referential integrity rules would be violated (3396)"
Therefore, all the relations are OK, set to "cascade
deletion".
What can I do ?
Many thanks
If you want to send me an email, just take out the dot
nospam from the address
I built a form with a sub-form who took its records in a
table. That table have relations with others, with
cascading deletions.
The deletion of a record in that file was working fine,
you delete it, and it was also deleting the records in the
other tables.
I had a 'crash' on that form. when I was opening it, I was
having a 'Watson'. Compacting didn't change anything.
So, I created a new database, and I imported all the
objects in it. It works. Everything is running fine.
But I can't delete anymore records in the subform. If I do
it, I have the message : "Cannot perform cascading
operation. Since related records exist in table <name>,
referential integrity rules would be violated (3396)"
Therefore, all the relations are OK, set to "cascade
deletion".
What can I do ?
Many thanks
If you want to send me an email, just take out the dot
nospam from the address