Programming Microsoft Dynamics NAV - Fifth Edition

Secondary keys and SumIndexFields

The Playlist Line table default primary key was the one field Document No. In order for the primary key to be unique for each record, another field is needed. For a line table, the additional field is the Line No. field, which is incremented through C/AL code for each record. So, we'll change the key for table 50003 accordingly:

We know a lot of reporting will be done based on the data in the Radio Show Ledger. We also know we want to do reporting on data by Radio Show and by the type of entry (individual song, specific ad, and so on). So, we will add secondary keys for each of those, including a Date field ...