# Update a collection property with another collection property linked to a user

**URL:** <https://forum.adalo.com/t/update-a-collection-property-with-another-collection-property-linked-to-a-user/37822>\
**Category:** Database\
**Created:** [April 7, 2023, 5:25am UTC](https://forum.adalo.com/t/update-a-collection-property-with-another-collection-property-linked-to-a-user/37822 "2023-04-07T05:25:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![LucasCaslu](https://avatars.discourse-cdn.com/v4/letter/l/e0b2c6/32.png) [@LucasCaslu](https://forum.adalo.com/u/LucasCaslu)\
**Post date:** [April 7, 2023, 5:25am UTC](https://forum.adalo.com/t/update-a-collection-property-with-another-collection-property-linked-to-a-user/37822/1 "2023-04-07T05:25:25Z")

</div>

Hello community,

I have a problem updating database property. Here’s where I’m stuck.

In my app I have 3 collections

- Users (can have 1 group and multiple posts)
- GROUP (can have multiple users and multiple posts)
- POST (can have 1 group and 1 user)

Basically a POST must have 4 properties : a description, a link, a linked USER and a linked GROUP.

Once a user is logged, he has a form to create a POST with a description and a link (2 properties)

The submit button of this form creates a POST with these two properties and updates the POST’s USER with current user infos.

But I can’t figure out how to update the fourth property which is the GROUP. I want it to be the current USER’s GROUP.

But when I want to “set automatically” the value, I can’t choose any option.  
Instead I have a loop of selection : Logged in user’s \> Group \> User OR Post \> Post OR Group… and so on.

Thanks for your help !!

---

<div class="post-metadata">

**Author:** ![Yongki](https://avatars.discourse-cdn.com/v4/letter/y/7c8e57/32.png) [@Yongki](https://forum.adalo.com/u/Yongki)\
**Post date:** [April 7, 2023, 12:28pm UTC](https://forum.adalo.com/t/update-a-collection-property-with-another-collection-property-linked-to-a-user/37822/2 "2023-04-07T12:28:00Z")

</div>

Hi @LucasCaslu ,

To update many-to-many relationship, use update action.

So, after create action, follow them with update action, and in this update action choose add to field’s name.