# Relationship properties

**URL:** <https://community.fibery.io/t/relationship-properties/887>\
**Category:** Ideas & Features\
**Tags:** flexible-domain\
**Created:** [August 7, 2020, 8:26pm UTC](https://community.fibery.io/t/relationship-properties/887 "2020-08-07T20:26:20Z")\
**Posts on this page:** 3\
**Page:** 3

<div class="post-metadata">

**Author:** ![Sev](https://avatars.discourse-cdn.com/v4/letter/s/90db22/32.png) [@Sev](https://community.fibery.io/u/Sev)\
**Post date:** [March 9, 2026, 2:44pm UTC](https://community.fibery.io/t/relationship-properties/887/41 "2026-03-09T14:44:53Z")

</div>

I think you may have brought me to realise a limitation. I thought we could expose an item’s children from the junction table at the item level itself, and therefore have a recursive relationship, but none of the lookup, formula or auto-relations fields allow this.

I was thinking we could have the [IR:Children] field be a formula of `[BOM Lines as Parent].Collection([Child Item])` to return a collection through BOM Lines, for all child items where the current item is a parent. But this is not possible, since the Collection function is not available.

Hopefully @Chr1sG can help shed some light on this.

---

<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:** [March 9, 2026, 5:34pm UTC](https://community.fibery.io/t/relationship-properties/887/42 "2026-03-09T17:34:24Z")

</div>

Sharing this as an example of how to achieve a multi level BOM view:  
`https://shared.fibery.io/t/fe7501b5-baf8-465d-bfc3-4ad13ab67e53-plm`

(discourse seems to mess with urls, so sharing it formatted as code)

---

<div class="post-metadata">

**Author:** ![Sev](https://avatars.discourse-cdn.com/v4/letter/s/90db22/32.png) [@Sev](https://community.fibery.io/u/Sev)\
**Post date:** [March 10, 2026, 1:24am UTC](https://community.fibery.io/t/relationship-properties/887/43 "2026-03-10T01:24:02Z")

</div>

Thanks @Chr1sG, using the group-by to add recursive levels is a trick I had forgotten, and kept looking for levels to add instead.

[Previous page](https://community.fibery.io/t/relationship-properties/887.md?page=2)
