I am new to FileMaker but I am familiar with database work mostly having worked with PHP/MySQL. I'm curious about how I should approach the following.
- I've created a database/layout that is keeping track of expenses. I have fields for "office", "vendor", "date", and "amount". No issues with entering the data. It works really slick.
- I enter expense amounts for (4) different offices. I enter in the name of the vendor, which office the expense belongs too, and the amount.
- I'd like to create a layout that displays (4) different columns...one for each office. I'd then like to list the vendor and amount under the office and finally have a total of each column.
What is the best way of approaching this? Thanks for the assistance.