Can I use subsummary values in another table?
I am quite a novice when it comes to working with Filemaker 10, but I am in the process of learning quite a lot. There is however one problem I have not been able to solve up till now.
What I would like to do is use subsummary values from one table, and display that in a field in another table, accompanied by its break field. To give an example: I have multiple customers that have three different kinds of subsummary values: amount paid, amount due, and total orders. These different subsummary values are all created in separate tables. What I would like to do is create an overview table, with in the first column the client name, and in the second, third and fourth column the client specific subsummary values, which FM takes from the other tables.
Up till now, I have not been able to find out of this is possible. I work with FM10.0v1 on a Mac, and am a novice with the software.
Hope someone can help.