Is there a way to cause an action to affect a data change on a different (non-child) table?
Specific example: I made an app that tracks textbooks at a school. There is a ‘inventory’ table of all books and an ‘activity’ table that tracks each book’s activity (assigned to student, returned, etc.). The inventory table has a ‘status’ column where users can mark that a book has been reported missing. Let’s say a book is marked missing, and then someone scans an ‘activity’ item for that book – I want the app to immediately recognize that the book is no longer missing, and run an action to change the value of the Status column in the ‘inventory’ table! Is there a way to do that?
Thanks in advance!