# Many to many to one, possible?

**URL:** <https://community.nocodb.com/t/many-to-many-to-one-possible/1839>\
**Category:** Grid-View\
**Created:** [April 30, 2025, 5:50pm UTC](https://community.nocodb.com/t/many-to-many-to-one-possible/1839 "2025-04-30T17:50:32Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dagaloni](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/dagaloni/32/684_2.png) [@Dagaloni](https://community.nocodb.com/u/Dagaloni)\
**Post date:** [April 30, 2025, 5:50pm UTC](https://community.nocodb.com/t/many-to-many-to-one-possible/1839/1 "2025-04-30T17:50:32Z")

</div>

I have no idea what this setup is called, but I do have a visualization of what I’m trying to do. 😇 (see below)

Each product has single attributes like SKU, name, category etc. The ingredients consists of two parts (actually three, but to keep it simple two parts): the ingredient name (which I want to have stored centrally in a table) and the amount.

I this setup possible? And if so, how? Oh and crucial, I would like to export the data to excel so I can import it via WP All Import to ACF.

Many thanks in advance! 😃

 ![Screenshot 2025-04-30 at 19.25.59](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/7727e32230d4c63c5debefb123c39582bbbf5142.png)

---

<div class="post-metadata">

**Author:** ![mertmit](https://avatars.discourse-cdn.com/v4/letter/m/dc4da7/32.png) [@mertmit](https://community.nocodb.com/u/mertmit)\
**Post date:** [April 30, 2025, 8:14pm UTC](https://community.nocodb.com/t/many-to-many-to-one-possible/1839/2 "2025-04-30T20:14:14Z")

</div>

Hi @Dagaloni

We support following relation types:

- many to many
- has many (=many to one)
- one to one
- belongs to (=one to many)

You can find detailed information on how to create them on [our documentation](https://docs.nocodb.com/fields/field-types/links-based/links/).

Also we have a video on relations which uses a related sample (Product - Details - Orders..) make sure to check it out [on youtube](https://www.youtube.com/watch?v=sbQvnZIUG6U).

For your use case (if I understand it correct) you need to create following relations between tables:

- **Product Ingredients → Products** (Has many)
- **Product Ingredients → Ingredients** (Has many)

Note that corresponding one to many relations (belongs to) will be automatically created.

---

<div class="post-metadata">

**Author:** ![Dagaloni](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/dagaloni/32/684_2.png) [@Dagaloni](https://community.nocodb.com/u/Dagaloni)\
**Post date:** [June 4, 2025, 7:30am UTC](https://community.nocodb.com/t/many-to-many-to-one-possible/1839/3 "2025-06-04T07:30:15Z")

</div>

Hi @mertmit  
Thank you! It got it working like you described. At first I stumbled upon some bugs when enabling the many-2-many system table, but it looks like they are fixed in the newest version, thank you!

However, I encountered a problem for me in the way it is exported to excel. In the table below you can see that Product A and Product B are linked to Vitamin A.

 ![Screenshot 2025-06-04 at 09.25.02](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/882a1cfd834e59897ade311cf96675fa00622345.png)

When I export it to excel I get the number of products (“2” in this example), instead of the actual names.

I wanted to create an excel file I could use to import in to my website to create these links.

For now it is a little too difficult for me to figure out how to do that semi-automatically via an import. If others want to achieve something similar, hopefully this thread helps!

---

<div class="post-metadata">

**Author:** ![mertmit](https://avatars.discourse-cdn.com/v4/letter/m/dc4da7/32.png) [@mertmit](https://community.nocodb.com/u/mertmit)\
**Post date:** [June 4, 2025, 7:49am UTC](https://community.nocodb.com/t/many-to-many-to-one-possible/1839/4 "2025-06-04T07:49:50Z")

</div>

Hi Dagaloni,  
For this you can make use of [Lookup field](https://nocodb.com/docs/product-docs/fields/field-types/links-based/lookup).

This way you can visualize any nested field from linked table. Which will be available on export as well.

---

<div class="post-metadata">

**Author:** ![Dagaloni](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/dagaloni/32/684_2.png) [@Dagaloni](https://community.nocodb.com/u/Dagaloni)\
**Post date:** [June 4, 2025, 8:22am UTC](https://community.nocodb.com/t/many-to-many-to-one-possible/1839/5 "2025-06-04T08:22:18Z")

</div>

Oh that is great, thank you!