December 12, 20178 yr 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.
December 12, 20178 yr 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
December 13, 20178 yr Author 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.?
Create an account or sign in to comment