Like my subject line says, I've inherited a Database in Filemaker 5.5. There are 12 related databases which contain figures from invoices which have been paid to 5 different accounts over time. Each payment has an account, country, category, sub category and item, amount, and payment quarter attached to it. I need to be able to see all the payments by by country, with the sum of the items grouped by subcategory, by payment quarter, while being able to compare the figures of each account. I'm trying to decide which tool to use to begin creating this layout. Any suggestions??
