In our application, we have decided to have several FlowFields and FlowFilters in Table 50000 Radio Show. The reason for these fields is to provide instant analysis for individual shows based on the detailed data stored in subordinate tables. In Chapter 2, Tables, we showed table 50000 with fields 100 through 130 and 1,090, but didn't provide any information on how those fields should be constructed. Let's go through that construction process now. Here's how fields 100 through 130 and 1,090 should look when we open table 50000 in the table designer. If you didn't add these fields as described in Chapter 2, Tables, in the Creating and modifying tables section, do that now:
The following five fields will be used for statistical analysis for each radio show:
- Field 100—Average Listeners: The average number of listeners, as reported by the ratings agency
- Field 110—Audience Share: The percentage of the...