Relational Data
Enterprise application data usually comes with lots of relations to other data. Hence accessing related data is important to be able to efficiently perform operational tasks such as identifying matching data, duplicate data or data anomalies. SQL Frames makes it possible to create such solutions very easily.
Master-Detail Pattern
Below is an example of selecting an Order and viewing the associated details records. Select an Order row and see how the associated Order Details records are displayed below.
It is possible to turn on the multi-select option in the Orders table and select multiple records and see the Order Details of all the selected Orders.
It is possible to get related data from multiple tables and see them all as tabs below the master table
Similar Transactions Pattern
Below is an example of selecting an Order and viewing related Orders (for example, based on Item Type and Sales Channel)