# No "hierarchical" option in List views for second-level DB?

**URL:** <https://community.fibery.io/t/no-hierarchical-option-in-list-views-for-second-level-db/4049>\
**Category:** Get Help\
**Created:** [February 23, 2023, 6:44pm UTC](https://community.fibery.io/t/no-hierarchical-option-in-list-views-for-second-level-db/4049 "2023-02-23T18:44:24Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![cannibalflea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/cannibalflea/32/318_2.png) [@cannibalflea](https://community.fibery.io/u/cannibalflea)\
**Post date:** [September 13, 2023, 11:38pm UTC](https://community.fibery.io/t/no-hierarchical-option-in-list-views-for-second-level-db/4049/4 "2023-09-13T23:38:20Z")

</div>

I offered a possible way of achieving [this here](https://community.fibery.io/t/representing-nested-relations/1405/15):

> [@Representing nested relations](https://community.fibery.io/t/representing-nested-relations/1405/15):
>
> I believe the simplest case would be to first start with the current database relation as the primary parent and if no relation is defined to the same database (i.e. relation is null), then we would go up one level and use that relation as the parent relation (if it exists). And so on up the levels until you get to the first level at which point if no relation exists, it gets captured under a “no parent” bucket.  
> …  
> **Approach**  
> Start by building each databases’s nested structure first (which is what fibery does for the first level):
> 
> ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/e/eded7061ff2bd0208fd114e27ca4a231642525c8.png)
> 
> Then in step 2, you start from highest level and move up and try to map all the root/level 1 items in the lower level databases:
> 
> ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/f/f72a035cab274e588452403b69bc6b7cdc5b9e70.png)

There was also a discussion [further down the same thread](https://community.fibery.io/t/representing-nested-relations/1405/22) on impacts on both 1-many and many-many relations.

I do hope there is a solution to this at some point as it allows for many interesting possibilities.

---

_[View the full topic](https://community.fibery.io/t/no-hierarchical-option-in-list-views-for-second-level-db/4049)._