# Multiple to multiple relations

**URL:** <https://community.glideapps.com/t/multiple-to-multiple-relations/52014>\
**Category:** Ask for Help\
**Created:** [October 18, 2022, 8:41pm UTC](https://community.glideapps.com/t/multiple-to-multiple-relations/52014 "2022-10-18T20:41:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![xbertschy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/xbertschy/32/5720_2.png) [@xbertschy](https://community.glideapps.com/u/xbertschy)\
**Post date:** [October 18, 2022, 8:41pm UTC](https://community.glideapps.com/t/multiple-to-multiple-relations/52014/1 "2022-10-18T20:41:32Z")

</div>

Hi,

I can’t understand how can work this scenario:

1 landlords own multiple properties and each property can be ownd at same time by multiple landlords.  
I can’t do that with Glide tables ? without creating duplicate datas ?

At this moment i have 2 tables. 1 for landlords, 1 for properties. On properties i put 1 column with the name of 1 landlords… i dont know how to add the second or third landlords… without duplicating the whole row and just changing the landlords… but if i do that the whole data of the properties are same on 2 or 3 rows (address, picture, etc…)

Please help me to understand 🙂 thx in advance

Xav

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [October 18, 2022, 9:20pm UTC](https://community.glideapps.com/t/multiple-to-multiple-relations/52014/2 "2022-10-18T21:20:17Z")

</div>

You can create a comma delimited list of landlord ID’s. Then use a Split Text column to split the list of landlords into an array. Then create your relation to the landlords table using that array. Likewise, you can create a relation linking the landlords table to the properties table.

---

<div class="post-metadata">

**Author:** ![xbertschy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/xbertschy/32/5720_2.png) [@xbertschy](https://community.glideapps.com/u/xbertschy)\
**Post date:** [October 19, 2022, 8:05pm UTC](https://community.glideapps.com/t/multiple-to-multiple-relations/52014/3 "2022-10-19T20:05:57Z")

</div>

Nice. I will try ! Thx for the tips !
