New tables for our WDTU project

First, we create a Playlist Header table (table number 50002), which will contain one record for each scheduled Radio Show:

Then we will create the associated Playlist Line table (table number 50003). This table will contain child records to the Playlist Header table. Each Playlist Line record represents one scheduled piece of music or advertisement or public service announcement or embedded show within the scheduled Radio Show defined in the Playlist Header table. The Description for each of the Option fields shows the information that needs to be entered into the OptionString, OptionCaption and OptionCaptionML ...

Get Programming Microsoft Dynamics NAV - Fifth Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.