I am working on application that tracks advertisements. The file contains the following tables; newspaper issue, advertising log, and company. The advertising log is linked to the company and newspaper issue tables.
The advertising log also contains four "status" type fields; production status which has a value between 1-4, ASR value which has 5 different text values, contract status which has 2 possible values and placement which has multiple text values.
I would like to create a status screen that would display the number of ads and or the $ for each status. Something like the following:
dateProduction StatusNumber of Ads
date ASR StatusNumber of Ads
Jan-1 confirmed bb
Jan-1 printed cc
Jan-1 invoiced dd
datePlacementNumber of ADsDollars
Jan-1 A xx $$
Jan-1 B xx $$
datecontract StatusSum of AD Price
Jan-1 New $$
Jan-1 OLD $$
I am fairly new to Filemaker and I not sure where to begin. Whether I can combine in one report or need to make multiple reports. Ideally this summary/status area would be above the detail advertising log screen. Any advice would be helpful.