Adding columns to table

In order to add new columns, open the table using the Tables module and under the Columns section tab, double-click on the Insert a new record text to insert a new entry in our new column. As this related list is pointing to the Dictionary table (sys_dictionary), any record that we enter in this embedded list will get stored into the Dictionary table as that is where information related to the columns is stored.

As shown in the following screenshot, set the value of the Column label field as Location Name, Type as String, and Max length as 40, and click on the green check icon to confirm:

We can insert multiple new rows to create more than one column in one go before clicking on the Submit button.

As shown in the following screenshot, insert two more rows with the following values:

• Column Label: Location Incharge, Type: Reference, Reference: User (sys_user)
• Column Label: Location, Type: Reference, Reference: Location (cmn_location)

Once you are satisfied with the new column's label and type, click on the Submit button to confirm our changes and create three new columns in the POS Location table. You can reopen the table's record in the Tables module to confirm the creation of these new columns:

We can double-click on any user-created fields to change its label or other values, as shown in the following screenshot. Make sure to click the Update button again to save your changes:

We can also click on the info icon next to each row to open up the record in the Dictionary detail form view.