---
title: "Select fields - ODBC"
slug: "select-fields-odbc"
tags: ["Task topic"]
status: "update"
updated: 2026-10-05T12:01:51Z
published: 2026-10-05T12:01:51Z
canonical: "docs.staedean.com/select-fields-odbc"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.staedean.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Select fields - ODBC

You can add a selection of table fields to a record.

You can select fields from an external table via **ODBC**. To connect to the external environment, use the default connector of type **Database**. You can set up this default connector for the applicable project.

To find the external table name, the name that is defined in the **Record** **table** field is used.

When the field selection is added to the record, review and complete the properties of the added fields.

### Steps

1. Click **Connectivity** **studio - Integration Design**.
2. Click the **Documents** tab.
3. In the list, find and select the desired document of type **ODBC**.
4. Click **Edit**.
5. In the **Record** section, in the **Record** list, find and select the desired record.
6. On the **Fields** tab, click **Select** **fields**.
7. The next steps explain several ways in which you can select fields. You can select all fields.

Click **Select** **all**.
8. You can undo all field selections.

Click **Deselect** **all fields**.
9. You can select mandatory fields only.

Click **Select** **mandatory**.

> [!NOTE]
> **Note**
> 
> You can also select fields manually.
10. Click **OK**.
11. Close the page.