Lookups

About

Lookups offer a convenient way to manually edit data in any database. Additionally, they can serve as a source for loop actions, enhancing flexibility in data processing.

Properties Dialogue

Parameters Tab

SQL Tab

Comments Tab

User Fields Tab

Data

Toolbar

The lookup toolbar provides all the tools you need in order to create and manipulate records in any database

1. Lookup Properties
   Access settings and configuration for the lookup.

2. Refresh Data Grid
   Reload the displayed data to reflect the most recent updates.

3. Create New Record
   Add a new entry to the database.

4. Post Changes to the Database
   Save modifications made to records in the database.

5. Delete Selected Records
   Remove the chosen records from the database.

6. Clone Record
   Duplicate an existing record for quick data entry.

7. Print
   Print the currently displayed data grid.

8. Print Preview
   View a preview of the data grid before printing.

9. Enable MRU (Most Recently Used) List
   Activate tracking of frequently accessed data entries.

10. Enable Incremental Search
    Allow for searching within the grid as you type.

11. Show Grouping Panel
    Display a panel to organize data into groups.

12. Show Vertical Grid
    Toggle the vertical view of the grid for better readability.

13. Export Data
    Save the data grid to a file in a supported format.

14. Import Data
    Load data into the grid from an external source.

15. Export Data into Excel
    Save the data grid directly as an Excel file.

16. Auto Format Grid
    Automatically adjust the grid layout for better presentation.

17. Read-Only Switch
    Toggle between editable and non-editable modes for the data grid.