Relation with property (junction table)

[nikkonrom]

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:

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

[mdubakov]

@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.

[nikkonrom]

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

[Chr1sG]

Related:

Relationship properties

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…