0

Enforcing Referential Integrity

Is there a simple way to tell Ninox that if I remove a parent record, all the child records in the child table would also be deleted?

What about cascading deletes? --> if I had parent:child:grandchild and deleted a parent record.

Perhaps this cascading delete happens automatically?

3 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    Ninox already does what you are wondering. You can always build a test DB and try it out.

      • Jim.5
      • 1 yr ago
      • Reported - view

      Fred Thanks, though maybe I wouldn't want that cascading delete behavior. Not sure how to control what Ninox would do.

    • Fred
    • 1 yr ago
    • Reported - view

    You can always change Composition to "No" then when you delete a record in the old Parent it won't delete the child.

Content aside

  • 1 yr agoLast active
  • 3Replies
  • 38Views
  • 2 Following