# \[DONE\] "Joins" - include related entity's fields in Views **URL:** \ **Category:** Ideas & Features\ **Tags:** table-view\ **Created:** [August 30, 2021, 6:37pm UTC](https://community.fibery.io/t/done-joins-include-related-entitys-fields-in-views/1966 "2021-08-30T18:37:42Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\ **Post date:** [August 30, 2021, 6:37pm UTC](https://community.fibery.io/t/done-joins-include-related-entitys-fields-in-views/1966/1 "2021-08-30T18:37:42Z")
Even _one-to-one_ Relations/Lookups only show a _link_ to the related entity. It would be very useful to be able to treat the related entity’s fields as if they were “native” fields belonging to the main entity (i.e., joined). E.g., to be able to show the related entity’s fields as columns in Table Views, or even in the main Entity View. …especially if we can edit these related fields as if they belonged to the main entity. ---
**Author:** ![Polina\_Zenevich](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/polina_zenevich/32/480_2.png) [@Polina\_Zenevich](https://community.fibery.io/u/Polina_Zenevich)\ **Post date:** [September 6, 2021, 3:35pm UTC](https://community.fibery.io/t/done-joins-include-related-entitys-fields-in-views/1966/2 "2021-09-06T15:35:57Z")
Hi, Matt! Maybe I didn’t get the problem - hope, you would help me here. 1. You can use a LookUp - get the fields you’re interested in as read-only ones on any of the level, and then manipulate them using as columns/filters/anywhere 2. If it’s more about the inheritance, you can set the same fields on all the levels and use automations to input values. Any use case or example is would be super helpful! ---
**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\ **Post date:** [September 6, 2021, 4:05pm UTC](https://community.fibery.io/t/done-joins-include-related-entitys-fields-in-views/1966/3 "2021-09-06T16:05:53Z")
Yes, this is related to Inheritance-like functionality: Example: If I have a _Project_ Type that is related ( **1:1** ) to a _SEO Info_ Type, my desire is for a _Projects_ Table View that can display and edit the fields of the related _SEO Info_ entity (if it exists). The issues with using Lookups for this are: 1. Each Lookup field must be manually created (cumbersome, and error-prone if field definitions change) 2. Lookups do not allow editing the related values in the Table View ---
**Author:** ![Polina\_Zenevich](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/polina_zenevich/32/480_2.png) [@Polina\_Zenevich](https://community.fibery.io/u/Polina_Zenevich)\ **Post date:** [September 7, 2021, 9:46am UTC](https://community.fibery.io/t/done-joins-include-related-entitys-fields-in-views/1966/4 "2021-09-07T09:46:38Z")
Haven’t tested it yet, but maybe Automations can work? So if you create same fields on both Entities, and they are field automatically based on each other’s values. So the trigger will be any of the fields updating. If I got the problem correctly, maybe this can work? How do you feel? ---
**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 7, 2021, 1:14pm UTC](https://community.fibery.io/t/done-joins-include-related-entitys-fields-in-views/1966/5 "2021-09-07T13:14:47Z")
I’m not sure it’s possible to define and use rules that are mirrors of each other (i.e. “If A changes, update B” and “If B changes, update A”) since it will probably trigger loop detection. Otherwise, they would repeatedly trigger each other. ---
**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\ **Post date:** [September 7, 2021, 2:38pm UTC](https://community.fibery.io/t/done-joins-include-related-entitys-fields-in-views/1966/6 "2021-09-07T14:38:42Z")
> [@Polina\_Zenevich](#): > > So if you create same fields on both Entities, and they are field automatically based on each other’s values. As you noted, this idea is an attempt to achieve a kind of type polymorphism – a “mixin” type. 🏏☠🐎 (beating a dead horse) I have two motivations here: - make related fields transparently available in all their contexts - reduce the work necessary to use related fields Manually duplicating fields into related types might work, but it is extra work, and clutters up our Types with duplicated Fields. 😢 Ideally all our data fields are unique, existing only in a single Type, and the relationships do all the hard work to make them appear in related contexts (Types). And ideally, they could always be _treated as if_ they were “native” fields in any context/Type where they appear. I can dream, right?? 😁 ---
**Author:** ![Polina\_Zenevich](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/polina_zenevich/32/480_2.png) [@Polina\_Zenevich](https://community.fibery.io/u/Polina_Zenevich)\ **Post date:** [September 8, 2021, 12:39pm UTC](https://community.fibery.io/t/done-joins-include-related-entitys-fields-in-views/1966/7 "2021-09-08T12:39:05Z")
Definitely! We’re dreamers too, so I’ll artefact your wonderful dreams and 🤞 some day we will see that in Fibery 🙂 ---
**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:** [April 2, 2026, 2:06pm UTC](https://community.fibery.io/t/done-joins-include-related-entitys-fields-in-views/1966/8 "2026-04-02T14:06:50Z")
released today > [@parrot April 2, 2026 / Show Fields from relation without Lookup, AI Integration Agent](https://community.fibery.io/t/april-2-2026-show-fields-from-relation-without-lookup-ai-integration-agent/10679): > > potted_plant Show Fields from relation without Lookup Now you can display Fields of related Entities on Views. Here are a couple typical use cases: On a Table View with Contacts, display columns for Contact → Company → State and Contact → Company → Revenue to understand how rude you can be nice you should be to each person. On an Entity View for Employees, show Employee → User → Vacations to save yourself a click. Unlike Lookups, these related Fields: are editable; respect acces…