Starting balance needs to come from a record in the same sheet

I am creating a database to track loans and extensions of these loans. I have one sheet for the original loan and set up another sheet that has extensions. I set up the Loans sheet so it has a reference to the extensions sheet so all extensions display in the primary loan sheet… The first extension starting amount pulls from a field in the Loan sheet. The problem I am having is on additional extensions. If I add another extension, I need it to get the end amount from the previous extension, not the same beginning balance I got for by first extension. Any suggestions?


I would suggest sending a support ticket via “Need Help” and share sheet URL and some example such like which field value should source from where. Then grant Ragic support access to your database so we could have a better understanding of your design and give you suggestions.