Design Table

Create

Appsystem->Design Tables->Actions->New Design Table

Now this form is appearing and click on Add New button under Tables section.

Enter required details and click on save button.

Listing of Design Tables

Go to Appsystem->Design Tables.

Define Table’s Columns

For define Table’s Column Click on Edit Design Table Structure right click on design tables.

This form is appearing now click on + sign button under columns section.

After Click on + button this form is appearing, now can enter columns details and click on OK button.

After entered column’s details and click on OK button.

DataType

We can set data type for columns as per require.

1. Lookup DataType: For Lookup DataType needs to set LookLinkCode & LookupTextCol

LookLinkCode--Need to set SchemaCode of Lookup table

LookupTextCol--Need to set TableCode of Table to Display.

2. List DataType: For List DataType need to set only LookLinkCode & no need to set LookupTextCol.

LookLinkCode--Need to set TableCode of Lookup table

After enter all columns to be shown like this.