Creating and modifying tables
In Chapter 1, An Introduction to NAV 2015, we created the Radio Show table for the WDTU application. At that time we used the minimum fields that allowed us to usefully define a master record. Now, let's set properties on existing data fields, add more data fields, and create an additional data table to which the Radio Show table can refer.
Our new data fields are shown in the following layout table:
|
Field No. |
Field Name |
Description |
|---|---|---|
|
1000 |
Frequency |
An Option data type (Hourly, Daily, Weekly, Monthly) for the frequency of a show; Hourly to be used for a show segment such as news, sports, or weather that is scheduled every hour. A space/blank is used for the first option to allow a valid blank field value. |
|
1010 |
PSA Planned Quantity |
A number (stored as an Integer) of Public Service Announcements to be played per show; this will be used by playlist generation and posting logic. |
|
1020 |
Ads Planned Quantity |
A number... |
