Can a numerical entry in one table cause a calculation in another table

My program is for a cat rescue with tables for caretakers, scheduling, cats, clinic appointments and surgery costs.  Currently I have a table for donations and expenses.  The cat table has surgery costs for each specific cat.  I am trying to create a program such that for a caretaker donation, the cat table will be accessed and the bill paid.  The payment will show up in the cat table.  The donate table will have a new record added representing the payment and a new caretaker balance will be created.  If the balance is positive, the cycle should be repeated, seeking out another cat for this caretaker that needs a payment.  I hope that my only input will be the amount of the deposit and all other transactions will be automatically made.  Does this seem possible.  So far am having no luck but am pretty new to ninox and for sure don't have a great grasp of it's capabilities