Languages

View and edit data

  • Viewing and editing data in table
  • Quick fulltext search
  • Filtering rows - fulltext search or SQL conditions
  • Sorting rows by clicking on column header, sorting by more columns
  • Lookups (preview of destination foreign key row), selecting rows from validation tables
  • Automatic master/detail views created from foreign keys
  • Forward/Back function for browsing master/detail views history

  • Table data view. Gray texts are lookups to destination tables. In the bottom window, there is a possibility to select other value from table referenced by foreign key.

    Showing master/detail view. In upper panel is master table (Customers), in bottom panel it's details (Orders table). In combo box above bottom table there is a possibility to choose foreign key, which is used for master/detail view.
     
    Table with active fulltext search.
     
    Table data editor - hexa view.