# How to update Entity when a related Entity changes (many-to-many)

**URL:** <https://community.fibery.io/t/how-to-update-entity-when-a-related-entity-changes-many-to-many/10107>\
**Category:** Get Help\
**Created:** [November 28, 2025, 8:40am UTC](https://community.fibery.io/t/how-to-update-entity-when-a-related-entity-changes-many-to-many/10107 "2025-11-28T08:40:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fabian](https://avatars.discourse-cdn.com/v4/letter/f/f6c823/32.png) [@Fabian](https://community.fibery.io/u/Fabian)\
**Post date:** [November 28, 2025, 8:40am UTC](https://community.fibery.io/t/how-to-update-entity-when-a-related-entity-changes-many-to-many/10107/1 "2025-11-28T08:40:31Z")

</div>

I have a many-to-many relationship between Deliverable and Work Package:

 ![Screenshot 2025-11-28 at 09.27.02](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/f/f4329d219b69faabf3a12c582e29461e3fc0eaf2.png)

Both have their own Status relation.

My goal is:

If all Work Packages of a Deliverable have the Status “Done”, the deliverable automatically sets its Status to “Ready For Review”.

I dont know where to define the rule:

1. in Deliverable, It seems that I cannot get a trigger when the status of a related Work Package changes. Else I suppose I could go over all related Work Packages to determine the Status of the Deliverable itself.
2. In Work Package, when the Status changes to “Done”, I would supposedly look into every Deliverable, iterate over the Work Packages, determine their Status and change that Deliverable. That doesnt seem the right place, and I didnt manage to automate that anyhow.

Do you have any Ideas?

In this screenshot you see, that for some reason, I cannot select Work Package, as a changed field of Deliverable:

 ![Screenshot 2025-11-28 at 09.39.07](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/7/7703d4a82585c10c042f81e5c8358fc080003c55.png)

---

<div class="post-metadata">

**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\
**Post date:** [November 28, 2025, 8:51am UTC](https://community.fibery.io/t/how-to-update-entity-when-a-related-entity-changes-many-to-many/10107/2 "2025-11-28T08:51:17Z")

</div>

Hey Fabian! Add a formula on the Deliverable to check the percantage of work packages that are done. Ask the AI “percantage of work packages that are done” and it should make the right formula.

Then the rule should trigger when that formula changes, and is equal to 100%.

Hope it works!

---

<div class="post-metadata">

**Author:** ![Fabian](https://avatars.discourse-cdn.com/v4/letter/f/f6c823/32.png) [@Fabian](https://community.fibery.io/u/Fabian)\
**Post date:** [November 28, 2025, 3:12pm UTC](https://community.fibery.io/t/how-to-update-entity-when-a-related-entity-changes-many-to-many/10107/3 "2025-11-28T15:12:54Z")

</div>

Hey Ron, thanks for the tip with the indirection. That works pretty well !