# Multi-select Relationship Column

A multi-select column allows users to select and enter multiple values for a single record in the field.

PowerTable allows you to add multi-select columns sourced from related tables. You can configure the multiple entries for a field to be retrieved from another table in the database.

To insert a multi-select visual column, follow the steps below.

Let us consider adding the 'Sales Rep' column to the 'Products' table, which allows users to enter sales representatives for each product.

{% stepper %}
{% step %}

### Go to **Setup > Columns**

![](/files/dc60216c0cf8044c32006e09fb0d4d3086da8330)

Setup > Columns
{% endstep %}

{% step %}

### Select **Add Visual Column > Add Multi-select Relationship Column**

![](/files/b48bc3502e1b943433b40260c43ef6e39f6779eb)

Add multi-select column

Alternatively, you can insert a new column from the 'Home' tab, as shown below:

![](/files/3264dc980aeaba91deba78d708d2dfbbabb8fe9d)
{% endstep %}

{% step %}

### Enter the column name

Let's add a 'Sales Rep' column that will allow users to assign multiple sales representatives to each product in the 'Products' table.

![](/files/0bf90b5be833e1d458b8e05b6e623b37cba012ec)
{% endstep %}

{% step %}

### Select the sales representative table

The sales representative details are available in another table with the 'Sales Rep Key' field and other fields.

![](/files/90b4739243ba9bff4fc1389e2b5d7c15ee0dfac2)

Sales Rep Table

{% hint style="info" %}
Note that a separate relationship table must exist in the database with these three fields—Primary ID, Product Key, Sales Rep Key.

If you do not already have a relationship table, create one manually using PowerTable (using the ‘New Table’ option)
{% endhint %}
{% endstep %}

{% step %}

### Enter the lookup table details

We would like to get the first names of sales representatives from the 'Sales Rep Table' and display the list in the dropdown.

![](/files/db044795a3ff7f74dff100958679ee6101be71d1)

Lookup table details
{% endstep %}

{% step %}

### Set up the relation table

Enter the name of the relation table, the corresponding reference column to map the lookup key values in the relation table, and the identifier column details that match the primary keys of the current and relation tables.

![](/files/cd2000c9ae8bd35c82306fe92edddc7197aae813)

Relation table details

This stores or updates the mapping between products and sales reps in the relationship table as we assign and unassign sales reps to the products in the app. Click **Save.**
{% endstep %}

{% step %}

### Review the multi-select relationship column

We have now successfully added a multi-select relationship column, which allows you to select and assign multiple sales representatives to each product.

![](/files/f9cadbf5d35ef6df250c0a4840d660089cc866c4)

Multi-select relationship column

After assigning, you can click **Save** and **Proceed** to save your changes to the database.

![](/files/597cfdb18df52bc6a74c30d57b2c559a47eaa714)

Save changes

The relation table is also simultaneously updated based on the selected values.
{% endstep %}
{% endstepper %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.fabricplan.com/powertable-sheets/how-tos/adding-columns-overview/add-visual-column/multi-select-relationship-column.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.