# How to search & compare 2 (or more) rows with data in different tables

**URL:** <https://community.glideapps.com/t/how-to-search-compare-2-or-more-rows-with-data-in-different-tables/32473>\
**Category:** Ask for Help\
**Created:** [September 29, 2021, 7:00pm UTC](https://community.glideapps.com/t/how-to-search-compare-2-or-more-rows-with-data-in-different-tables/32473 "2021-09-29T19:00:05Z")\
**Posts on this page:** 1\
**Showing post:** 27

<div class="post-metadata">

**Author:** ![santer1982](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santer1982/32/32453_2.png) [@santer1982](https://community.glideapps.com/u/santer1982)\
**Post date:** [October 21, 2021, 7:28pm UTC](https://community.glideapps.com/t/how-to-search-compare-2-or-more-rows-with-data-in-different-tables/32473/27 "2021-10-21T19:28:56Z")

</div>

@Jeff_Hager I’ve figured it out finally. It’s a mix of what you suggested and some explanations in this topic [Calculation/Relation with previous (list) data in inline list? Global var?](https://community.glideapps.com/t/calculation-relation-with-previous-list-data-in-inline-list-global-var/33326)

What was done in DB:

1. Separate table with 1 row. Columns: Text(could be also template as you wrote)=“key”, User specific1="", User specific2=""

2. Pills table. New columns: Template=“key”, Relation=Template.key in separate table.key  

3. Interactions table. New columns: Single value choice=Separate table.userspecific1, Single value choice=Separate table.userspecific2, IsInteract (IfThenElse column as Darren\_Murphy described above but based on new sv columns).  

What was done in UI:

1. 2 buttons in new tab each writing main\_component trough the relation column to its own column in the separate table
2. Inline list with source of interactions table and with filter by IsInteract positive value.

Thanks again for your help.

---

_[View the full topic](https://community.glideapps.com/t/how-to-search-compare-2-or-more-rows-with-data-in-different-tables/32473)._