# 1-1 mapping \[Jul 21\]

**URL:** <https://community.nocodb.com/t/1-1-mapping-jul-21/609>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 10:31am UTC](https://community.nocodb.com/t/1-1-mapping-jul-21/609 "2022-11-03T10:31:15Z")\
**Posts on this page:** 8\
**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, 10:31am UTC](https://community.nocodb.com/t/1-1-mapping-jul-21/609/1 "2022-11-03T10:31:15Z")

</div>

> 🙋‍♂️ **lublak** _asked_

## Another question not ssl related.

#### Can i like a single column with another table 1:1?

#### I have a table with a number and description field. (descri\_table)

#### I have my table that should have a column which alows to pick a data (dropdown) based on descri\_table description. But it should use the numer for insert.

---

<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, 10:31am UTC](https://community.nocodb.com/t/1-1-mapping-jul-21/609/2 "2022-11-03T10:31:16Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### You can consider creating a table for `number` and `description`. Let’s call it option table.

#### 

#### From your source table, create a link (LTAR) for option table. You can establish link between source table & option table by using this field. Add another look-up in source table to display associated number from option 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, 10:31am UTC](https://community.nocodb.com/t/1-1-mapping-jul-21/609/3 "2022-11-03T10:31:18Z")

</div>

> 🙋‍♂️ **lublak** _replied_

#### \<@857998597474484295\> it has only “many” options:

 ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/5c7f6125902be188f89e8a8480f292ca50e2f3ad.png)

#

---

<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, 10:31am UTC](https://community.nocodb.com/t/1-1-mapping-jul-21/609/4 "2022-11-03T10:31:19Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### There is no explicit 1-1 mapping. We can use `Single select` column type, but then, we will not be able to get associated index

#

---

<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, 10:31am UTC](https://community.nocodb.com/t/1-1-mapping-jul-21/609/5 "2022-11-03T10:31:20Z")

</div>

> 🙋‍♂️ **lublak** _replied_

#### Would this be a feature request?

#

---

<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, 10:31am UTC](https://community.nocodb.com/t/1-1-mapping-jul-21/609/6 "2022-11-03T10:31:21Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### It can be a feature request. You can help us understand your use-case in detail when you request.

#

---

<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, 10:31am UTC](https://community.nocodb.com/t/1-1-mapping-jul-21/609/7 "2022-11-03T10:31:22Z")

</div>

> 🙋‍♂️ **lublak** _replied_

#### I have a table where numbers have to be entered. These number codes are stored in the database by another system with a description.

#### ```

#### code\_description\_table

#### | number | description |

#### | ------ | ----------- |

#### | 890 | test |

#### | 840 | work |

#### ```

#### Now I have a second table with inputs.

#### ```

#### input\_table

#### | somefield | anotherfield | code |

#### | --------- | ------------ | ---- |

#### | blabliblu | lala | 890 |

#### ```

#### Of course, it is not pleasant to work with such numbers.

#### Therefore, a dropdown would be really cool which displays the description in the dropdown instead of the number (i.e. code\_description\_table.description). So link record but only with a single value.

#### With input\_table.code, it would make sense to place a foreign key on code\_description\_table.number.

#

---

<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, 10:31am UTC](https://community.nocodb.com/t/1-1-mapping-jul-21/609/8 "2022-11-03T10:31:23Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/999306492635262976)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)