john9210 Posted December 12, 2017 Posted December 12, 2017 I would like to set up a solution that keeps track of account financial data. The primary table has the account name and other data. The related table has three fields: deposits, withdrawals and balance. I would like to calculate the total deposits, total withdrawals and current balance, and display them in the primary table.
Lee Smith Posted December 12, 2017 Posted December 12, 2017 Hi John, You are describing a Check Register. phil over at community replied with this post which I followed to create my attachment. https://community.filemaker.com/thread/92249#comment-283297 Check Register.fmp12
john9210 Posted December 13, 2017 Author Posted December 13, 2017 Thanks, that was helpful. Since I will use these fields will be in a child table, I also need to display the total of deposits, the total of withdrawals and the last value (the current balance) in the primary table. How can I do that.?
Recommended Posts
This topic is 2605 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now