...
- Navigate to Configuration > External Databases.
- Enter the queries and define other settings. For example:
Linking an Overview to a Detail View
...
- Select the desired overview query (Configuration > Queries Queries tab).
- Under "Column settings" add a column for the record ID field and check "NT" for "Do not show".
- In order for the field to be linked, select "New link" under "Column settings" or "Modify link" if a link already exists.
- From the "Field" drop-down list, select the ID field(in this example "personid").
- From the "To" drop-down list, select the desired detail view. Click [Save].
- Click [Close]. The overview query looks like this:
...