Trouble with summary fields
Background Info: I am using the following
- Filemaker pro Advanced 11
- Mac OS X 10.6.5
- Single user mode
- 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.