# Show 2 Relation Fields from the Same Database in 1 View or Field

**URL:** <https://community.fibery.io/t/show-2-relation-fields-from-the-same-database-in-1-view-or-field/8708>\
**Category:** Get Help\
**Created:** [May 2, 2025, 5:22pm UTC](https://community.fibery.io/t/show-2-relation-fields-from-the-same-database-in-1-view-or-field/8708 "2025-05-02T17:22:23Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bronn](https://avatars.discourse-cdn.com/v4/letter/b/b5a626/32.png) [@Bronn](https://community.fibery.io/u/Bronn)\
**Post date:** [May 2, 2025, 5:22pm UTC](https://community.fibery.io/t/show-2-relation-fields-from-the-same-database-in-1-view-or-field/8708/1 "2025-05-02T17:22:23Z")

</div>

I have a few use cases where I have two fields, but I want to show all items from both fields in one (view or field) to make it easier from users. A few examples, but there are many other areas where it’s relevant:

1. An application has a **Case Officer** and a **Submitter**. They both relate to the **Project Contacts** database and are therefore **2 fields** on both databases. This is fine for the Application database, but **in the Project Contact, I want to show all Applications relating to that contact in one View** , rather than “Applications where this contact is the Case Officer” and “Applications where this contact is the Submitter”.
2. **Projects** have **Related Projects**. Because it’s a relation to the same database, it creates 2 fields. **When a related project is added, the current project shows in a 2nd field for the related project.** Again, I’d like to consolidate these so users don’t have to check 2 fields/views, which is unintuitive and takes up too much space.

I cannot seem to create a formula that lets me consolidate these 2 fields, or a view that will show both dynamically.