For this application, we want our FactBox to display information relating to the specific radio show we are scheduling. The information to be displayed includes the five show segment requirements and the status of fulfillment (counts) of those requirements by the data that's entered into date. The requirements come from the Playlist Header fields: PSAs required, advertisements required, news required, sports required, and weather required. The counts come from summing up data in the Playline Line records for a show. We can use the Playlist Header field's PSA count and ad count for those two counts. These counts can be obtained through the FlowField property definitions we defined earlier for these two fields.
For the other three counts, we must read through the Playlist Line and sum up each of the counts. To accomplish that, we'll create a function that we can call from the FactBox page. Since our new function is local to the Playlist...
