Active-table-editor
Active Table Editor Menu Items
Menu Items are the construction blocks used to design user menus. In other words, the Menu item is a result of the execution of SQL statement associated with the Icon and appropriate Description.
Note: Please always remove comments from SQL
The parameters are called <PARAMETER_1> and
Note: To refresh the screen enter the value and press enter
Menu items’ types
- Table
- Record
- Table/Record
- Vertical Table
- Master Details
- Report
Table Item
Record Item
Table/Record Item
Using Database Lookup
Note: The first field is a lookup key the second is a lookup value
Vertical Table
Master/Details
Linking Master and Details
Report Item
Note: Additional information is provided in a separate help file
Report design can be changed within the items list or with the item itself
Form Designer - Grid
Form Designer - Record
Report Designer
Video Tutorials
We have more videos on ETL-Tools.com YouTube Channel,
Please take a look and subscribe to stay updated with the latest content.
Confused? Ask question on our ETL Forum