Skip to content

User Defined Tables

Create User Defined Tables

Just like the pre-defined tables in the application, the user can define Custom Tables called User Defined Tables. In this example, we discuss Defining the New Table, Attaching it to Menu and User Authorization.

Parent Child Relation

The user can define a relation between two Custom Tables. If there is a Child and Parent Relation between two Tables, then the user can access the Child Table with a right-click on the Parent Table. Step by Step procedure to define this Relation is discussed in this file.

When values in the column are limited and there is a repetition of these columns, then Drop Downs can be defined so that the data can be filled in the table quickly.

When a column has multiple data, it is difficult to enter each data manually. So the user can make use of Queries to define the data with an appropriate Query and when wishes to add value to that column, the list of Data will appear according to the Query.

Dependency

When one column is dependent on the other, a dependency can be given while defining the Table. Once the user selects data in the Primary column, the Secondary column will be updated as per dependency.

Add Formula

When the user needs to perform an arithmetic operation between two columns of the Table, it can be done by defining the formula with appropriate syntax. This file consists of an example of Adding values of two columns.

Default Values

Sometimes the user wants values in some columns to be updated automatically, Default Values are used in such cases. Here in this example, we are given Default Value that automatically updates the Serial Numbers in the column.

Date, Time and Check Box

When the user wishes to give an option defining Time in the column, it can be done with proper syntax. Along with it, we also discuss the checkbox option in the User Defined Tables.

Display tables from Grid Row -Header

Usually, Tables are attached to the Menu Bar and accessed from the Menu Bar itself. If the user wishes to access any of the User Defined Tables by just right click on the Grid-Row Header, it must be specified during defining the Tables.