Modifying a standard table
One of the big advantages to the NAV system development environment is the fact that we are allowed to enhance the tables that are part of the standard product. Many package software products do not provide this flexibility. Nevertheless, with privilege comes responsibility. When we modify a standard NAV table, we must do so carefully.
In our system, we are going to use the standard Item table – Table 27, to store data about recordings such as music, advertisements, and PSAs which we have available for broadcast. One of the new fields will be an Option field. Another will refer to the Publisher table we created earlier. When the modifications to the Item table design are completed, they will look like the following image:
Note that we were careful not to touch any of the standard fields that were already defined in the Item table. Plus, we numbered all our new fields in the range of 50000 to 99999, making them easy to identify as belonging to a Partner...
