For this discussion, we will divide table types into three groups. As developers, we can change the definition and the contents of the first group (the Fully Modifiable tables). We cannot change the definition of the base fields of the second group, but we can change the contents (the Content Modifiable tables) and add new fields. The third group can be accessed for information, but neither the definition nor the data within is modifiable (the Read-Only tables).
The following tables are included in the Fully Modifiable Tables group:
The Master table type contains primary data (such as customers, vendors, items, employees, and so on). These are the tables that should be designed first because everything else will be based on these tables. When working on a modification, any necessary changes to Master tables should be defined first. Master tables always use card pages as their primary user input method. The Customer table is a Master table. A Customer...