# Link to multiple columns \[Feb 12\]

**URL:** <https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220 "2022-11-03T08:04:21Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/1 "2022-11-03T08:04:21Z")

</div>

> 🙋‍♂️ **vikiiingur** _asked_

## I have a reference table (`Table1`) with a list of names and other data, every row is 1 person name. In `Table2` I want to link to the reference table in multiple columns. When I request `LinkToAnotherRecord`, it allows only 1 `has_many` and 1 `has_to_many` reference. How do I link to the reference `Table1` **across multiple columns** in `Table2`?

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/2 "2022-11-03T08:04:22Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### After you link two tables using (LinkToAnotherRecord), you can use LookUp or RollUp column type to extend further

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/3 "2022-11-03T08:04:23Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### [https://docs.nocodb.com/setup-and-usages/lookup](https://docs.nocodb.com/setup-and-usages/lookup)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/4 "2022-11-03T08:04:25Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### [https://docs.nocodb.com/setup-and-usages/rollup](https://docs.nocodb.com/setup-and-usages/rollup)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/5 "2022-11-03T08:04:26Z")

</div>

> 🙋‍♂️ **vikiiingur** _replied_

#### Yes, I tried. My problem is that Table1 is a list of names in _ **rows** _, Table2 I want to put multiple Table1 names into _ **columns** _

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/6 "2022-11-03T08:04:27Z")

</div>

> 🙋‍♂️ **vikiiingur** _replied_

#### Example Table1:

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/7 "2022-11-03T08:04:28Z")

</div>

> 🙋‍♂️ **vikiiingur** _replied_

#### John

#### Victoria

#### Edith

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/8 "2022-11-03T08:04:29Z")

</div>

> 🙋‍♂️ **vikiiingur** _replied_

#### Table2:

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/9 "2022-11-03T08:04:30Z")

</div>

> 🙋‍♂️ **vikiiingur** _replied_

#### Project Name | Project Leader | Collaborator

#### NOCODB | John | Victoria, Edith

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/10 "2022-11-03T08:04:31Z")

</div>

> 🙋‍♂️ **vikiiingur** _replied_

#### all in one row

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/11 "2022-11-03T08:04:32Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### Something like transpose in excel/ spreadsheet. Not possible with NocoDB.

#### 

#### One option I see is, download as CSV & transpose in excel/ spreadsheet & then import excel.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/12 "2022-11-03T08:04:33Z")

</div>

> 🙋‍♂️ **vikiiingur** _replied_

#### no, I do not need transpose, this has already been done

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/13 "2022-11-03T08:04:35Z")

</div>

> 🙋‍♂️ **vikiiingur** _replied_

#### I have a list of names that is normalized - authoritative, and I want these names to be the same across multiple tables, so I created Table1 as a reference table

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/14 "2022-11-03T08:04:36Z")

</div>

> 🙋‍♂️ **vikiiingur** _replied_

#### now in other tables I want to use these names in multiple columns, based on their role

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/15 "2022-11-03T08:04:37Z")

</div>

> 🙋‍♂️ **vikiiingur** _replied_

#### I am afraid this is not transposition

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/16 "2022-11-03T08:04:38Z")

</div>

> 🙋‍♂️ **vikiiingur** _replied_

#### best I would describe it as a multilink

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/17 "2022-11-03T08:04:39Z")

</div>

> 💁 **o1lab** _replied_

#### Got it, like a template tables from which you want to create tables.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/18 "2022-11-03T08:04:40Z")

</div>

> 🙋‍♂️ **vikiiingur** _replied_

#### yup

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/19 "2022-11-03T08:04:41Z")

</div>

> 💁 **o1lab** _replied_

#### Pls raise it as a feature request. This could be done.. but guess we ve to handle types for all DBs

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:04am UTC](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220/20 "2022-11-03T08:04:42Z")

</div>

> 🙋‍♂️ **vikiiingur** _replied_

#### [[Feature] Multilink between tables · Issue #1158 · nocodb/nocodb · GitHub](https://github.com/nocodb/nocodb/issues/1158)

#

[Next page](https://community.nocodb.com/t/link-to-multiple-columns-feb-12/220.md?page=2)