# Split Relation

**URL:** https://community.glideapps.com/t/split-relation/71095
**Category:** Ask for Help
**Created:** [February 23, 2024, 3:59pm UTC](https://community.glideapps.com/t/split-relation/71095 "2024-02-23T15:59:56Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Gary\_Willmott](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_willmott/32/837_2.png) [@Gary\_Willmott](https://community.glideapps.com/u/Gary_Willmott)
#### Post date: [February 23, 2024, 3:59pm UTC](https://community.glideapps.com/t/split-relation/71095/1 "2024-02-23T15:59:56Z")

</div>

From what I [read about multi relation](https://community.glideapps.com/t/lookup-multiple-relation/30124/6), it doesn’t look possible. However I want to see if there is a work around

I want todo a count of people in a certain status. However I need to split the group to show people that are in a certain Church. This is for a multi-church CRM and each person is in 1 of 5 churches and each person is in 1 church

See below

 ![Screenshot 2024-02-23 at 17.57.00](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/1/e1e923bcf032bc8800722a8927e186a558cc745b.png)

---

<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: [February 23, 2024, 4:10pm UTC](https://community.glideapps.com/t/split-relation/71095/2 "2024-02-23T16:10:25Z")

</div>

Couldn’t you use Query column with a condition that matches status church?

---

<div class="post-metadata">

### Author: ![Gary\_Willmott](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_willmott/32/837_2.png) [@Gary\_Willmott](https://community.glideapps.com/u/Gary_Willmott)
#### Post date: [February 23, 2024, 4:31pm UTC](https://community.glideapps.com/t/split-relation/71095/3 "2024-02-23T16:31:52Z")

</div>

Legend @Jeff_Hager🙏

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [March 1, 2024, 4:32pm UTC](https://community.glideapps.com/t/split-relation/71095/4 "2024-03-01T16:32:35Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.