# Help: Horizontal Chip Not working in many-to-many relationship

**URL:** <https://forum.adalo.com/t/help-horizontal-chip-not-working-in-many-to-many-relationship/51892>\
**Category:** Get Help\
**Created:** [December 11, 2024, 7:54am UTC](https://forum.adalo.com/t/help-horizontal-chip-not-working-in-many-to-many-relationship/51892 "2024-12-11T07:54:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![varosa123](https://avatars.discourse-cdn.com/v4/letter/v/47e85d/32.png) [@varosa123](https://forum.adalo.com/u/varosa123)\
**Post date:** [December 11, 2024, 7:54am UTC](https://forum.adalo.com/t/help-horizontal-chip-not-working-in-many-to-many-relationship/51892/1 "2024-12-11T07:54:57Z")

</div>

We have a horizontal chip list showing service categories. When a user selects a category, it should filter another list of businesses to show only those linked to the selected category.

To do this:

1. Relationships: We set up many-to-many relationships between the Service Category Collection and Business Collection because one business can have multiple categories.

2. Temporary Field: In the Users Collection, we created a temporary field called Selected Category. This field is meant to store the category the logged-in user selects from the chip list.

3. Filter Logic: We added a filter to the Business Collection list. This filter checks if the businesses are associated with the category stored in the logged-in user’s Selected Category. The filter we wanted was “Current Business Collection \> Service Category \> All contains Logged In User’s selected category.”

Problem: The issue is that we got the first section “Current Business Collection \> Service Category”, however, we did not get Logged In User’s selected category. Note: We do not want to use 1 to many relationship because that doesn’t meet our business expectations.

 ![Screenshot 2024-12-10 at 11.58.44 PM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/3/3/33ebdaceca3a4d376adc6f61cc9beb76efee200a.png)  
 ![Screenshot 2024-12-11 at 12.00.18 AM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/6/3/63d1ffabc4e292adb9686a08934a9da123f914c0.png)

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [December 21, 2024, 7:55am UTC](https://forum.adalo.com/t/help-horizontal-chip-not-working-in-many-to-many-relationship/51892/2 "2024-12-21T07:55:10Z")

</div>

Closed on December 21, 2024, 7:55am UTC

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