I've been trying to set triggers up to create a payment table for amortized loans. I'm able to get all the fields to work correctly except updating the principal amount paid each month. On the insert of a loan table, I'm creating a payment table based on the number of payments, loan loan amount and interest rate passed. I also pass the initial principal payment although it seems like I should be able to do the necessary calculation in the triggers. Most of the trigger works as expected buy I can seem to find the correct combination to correctly update the Principal Payment. I've tried various combinations and keep running into various errors when I try different ways. Please let me know what I'm doing wrong.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Mary99
I've been trying to set triggers up to create a payment table for amortized loans. I'm able to get all the fields to work correctly except updating the principal amount paid each month. On the insert of a loan table, I'm creating a payment table based on the number of payments, loan loan amount and interest rate passed. I also pass the initial principal payment although it seems like I should be able to do the necessary calculation in the triggers. Most of the trigger works as expected buy I can seem to find the correct combination to correctly update the Principal Payment. I've tried various combinations and keep running into various errors when I try different ways. Please let me know what I'm doing wrong.
![Pmt Table.png](//content.invisioncic.com/r269793/monthly_2022_10/722771107_PmtTable.png.2db32162d1153e68c0c63a56e7d82655.png)
Edited by Mary99Included the wrong table image
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.