AnsweredAssumed Answered

Trouble with summary fields

Question asked by pdoak_1 on Dec 16, 2010
Latest reply on Dec 17, 2010 by pdoak_1


Trouble with summary fields


Background Info: I am using the following

  1. Filemaker pro Advanced 11
  2. Mac OS X 10.6.5
  3. Single user mode
  4. I have been using Filemaker Pro for a couple of months

I have one table which lists client id's and client accounts numbers.  One client can have multiple accounts.  In another table, I have the client account nos, the balance on the account listed by date.

I have used the following join relationship:

Table1:RefDate = Table2:Date and

Table1:client account = Table2:client account.

However, I cannot seem to produce a layout which shows the client accounts and their corresponding balance for the chosen RefDate.  I can list the accounts but the balance field is blank.  In addition, I want to be able to show the total of all client balances for that day as a sub-total.  

I am sure that this must be simple but I just can't seem to get it to work.