Problems with Get Summary from related table occurence
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 month
I have two tables both of which summarise data by ClientID. I wish to produce a layout which uses the total of the two summarised data for other calculations within the layout. I can produce two separate layouts which correctly reflect the summary data either by using Get Summary or by creating a "summary" field. I can even produce the correct summary data for each field on one layout using the Summary field created in each table. However, when I try and capture the summary data from the other table using Get Summary, it does not pick up any data at all for the field using Get Summary from the other table.
I am sure that I am making a basic error but cannot see what the problem is. Any suggestions would be appreciated.