# Relation with property (junction table)

**URL:** <https://community.fibery.io/t/relation-with-property-junction-table/693>\
**Category:** Bugs & Issues\
**Created:** [May 10, 2020, 11:19am UTC](https://community.fibery.io/t/relation-with-property-junction-table/693 "2020-05-10T11:19:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nikkonrom](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/nikkonrom/32/222_2.png) [@nikkonrom](https://community.fibery.io/u/nikkonrom)\
**Post date:** [May 10, 2020, 11:19am UTC](https://community.fibery.io/t/relation-with-property-junction-table/693/1 "2020-05-10T11:19:25Z")

</div>

**Case: relation without properties**  
Types: Recipe and Product.  
Relation: there is a product in many recipes and one recipe contains many products (many-to-many)  
Solution: two tables

**Case: relation with property**  
Types: Recipe, Product and ProductRecipe  
Relation: there is a product in the recipe **with a certain gram** and vice-versa  
Solution: three tables

In result of second solution i have this table:

 ![Screenshot from 2020-05-10 14-10-51](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/9/90a42ff1c80c55f5711d3a107c3bc8ab44500b70.png)  
Table of ProductRecipes

And it’s not convenient cause i can’t click to Product or Recipe cell and open it’s entity, this table allows me only change it, also i must have one ephemeral type, that not represent real entity.  
How to properly solve “relation with property” problem?

Maybe guys you were considering about lightweight relation types with ability to storing information there instead of creating new type?

_How Airtable solving this problem: [Link](https://support.airtable.com/hc/en-us/articles/218734758-A-beginner-s-guide-to-many-to-many-relationships#junction)_

---

<div class="post-metadata">

**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\
**Post date:** [May 10, 2020, 3:38pm UTC](https://community.fibery.io/t/relation-with-property-junction-table/693/2 "2020-05-10T15:38:34Z")

</div>

> [@nikkonrom](#):
>
> And it’s not convenient cause i can’t click to Product or Recipe cell and open it’s entity,

You can do it in fact. Hold Option/Alt key and click the Product or Recipe in the table. It will open in a popup.

We do have this in mind, but not sure when we’ll get to it.

---

<div class="post-metadata">

**Author:** ![nikkonrom](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/nikkonrom/32/222_2.png) [@nikkonrom](https://community.fibery.io/u/nikkonrom)\
**Post date:** [May 10, 2020, 5:56pm UTC](https://community.fibery.io/t/relation-with-property-junction-table/693/3 "2020-05-10T17:56:03Z")

</div>

Thanks, i’ve tried Ctrl + click and Shift + click, but I didn’t have enough 😄

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [September 26, 2024, 3:54pm UTC](https://community.fibery.io/t/relation-with-property-junction-table/693/4 "2024-09-26T15:54:09Z")

</div>

Related:

> [@Relationship properties](https://community.fibery.io/t/relationship-properties/887):
>
> This might be a big ask, but would it be possible to add properties to relationships as well as entities (like is possible with a graph database)? I realise that the more sophisticated you make the underlying platform, the greater the risk of users being scared away by the complexity, but for me, it would put you into a whole different league. It could be a feature that can be enabled but is disabled by default so as to not scare non-techies…