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?

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 10 days ago
    • Reported - view

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

    Like
      • Jim
      • Jim.5
      • 10 days ago
      • Reported - view

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

      Like
    • Fred
    • Fred
    • 10 days 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.

    Like
Like Follow
  • 10 days agoLast active
  • 3Replies
  • 19Views
  • 2 Following