Filtering a calculation
This is my first post on this forum! I am trialling FMP as a better solution to MS Access because it runs on Macs.
For the last week I have been trying to overcome what appears to be a simple problem, but for the life of me I cannot find how to solve this in FMP. There are some conceptual differences between FMP and Access some of which still clearly elude me!
I have put together a very simple DB with 2 tables with a one-to-many relationship. Basically I need to display information from the first table grouped by Category and show the total amount from Table 2 next to each category. This is not difficult to achieve by having a calculated field in Table 2. The problem is that I need the data to be filtered. How do you filter a calculation in a field? The layout is filtered by writing a script, but this is ignored by the field.
I have created a simple sample file to illustrate 'the problem' but I am not sure if I can upload it here!
Any guidance would be very much appreciated. Thank you.