Creating custom tables

Data is the core of any business application. We will start developing our solution from designing the data model. The first recipe will show how to create custom tables, set up field references and configure FlowFields that are calculated by the NAV platform based on table data.

How to do it...

In this recipe, we design the data model for the solution.

1. Open Object Designer and select Table in the list of object types. Click New. Table designer will open.
2. Each table field must have a number, a name, and a data type. Number 1 is already assign automatically. In the Field Name field enter No. and choose Code as Data Type. Finally, enter 20 in Length. This will create a Code[20] field.
3. Move to the next empty line. Field No. will automatically increment. Enter CA Code in Field Name, Code in Data Type, and 20 in Length.
4. Create other fields as given in the following table:

   Field No.	Field Name	Data Type	Length
   1	No.	Code	20
   2	CA Code	Code	20
   3	Item No...