Searching Multiple Tables to Produce Summary Results

[Jim Davis]

I am new user of FMP and struggling with some of the 'basic' programming actions. I have extensive experience with ACCESS. My problem, I have 3 related tables each containing an account number which is obtained from a value list. I want to summarize results for each account in a single line item report and show a date sorted sub-total by each line item. For example, if I have debit, payment and credit tables and want to keep these tables separate but still summarize the results, how do I perform that find?

Account X

Date Tranasaction Amount Balance

dd-mm Debit 1.00 -1.00

dd-mm Credit 0.50 -0.50

dd-mm Payment 0.50 0.00

Current Bal = 0.00