santonivich

How to display results of multiple office locations

Discussion created by santonivich on Jul 5, 2017
Latest reply on Jul 5, 2017 by philmodjunk

Hello,

 

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.

Outcomes