# How to search & compare 2 (or more) rows with data in different tables **URL:** \ **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:** 8\ **Page:** 2
**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 19, 2021, 12:49pm UTC](https://community.glideapps.com/t/how-to-search-compare-2-or-more-rows-with-data-in-different-tables/32473/21 "2021-10-19T12:49:23Z")
At this point, I think you would have to submit a support request to Glide. [https://glide-help.zendesk.com/hc/en-us/requests/new](https://glide-help.zendesk.com/hc/en-us/requests/new) ---
**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 19, 2021, 5:33pm UTC](https://community.glideapps.com/t/how-to-search-compare-2-or-more-rows-with-data-in-different-tables/32473/22 "2021-10-19T17:33:30Z")
> [@Jeff\_Hager](#): > > This would require you to first have a new sheet with a single row that will act as your tab. You will need a template column that can be filled with the word ‘key’. Create a similar template in your pills table. Then create a single relation in your pills table that links the key template to the key template in the new table. Could you please get more details on this. 1. I created a new table with a template column. 2. I created 2 rows in existed table (template + relation) I’m confused about where to put 2 values from pills list to compare. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/df0c60f8c9621cacb72364bfb1eaf4f8ef35f960.png) And after all, even if I put main\_component values to the new table, how it correlates with the solution described by Darren\_Murphy above? ---
**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 20, 2021, 6:15pm UTC](https://community.glideapps.com/t/how-to-search-compare-2-or-more-rows-with-data-in-different-tables/32473/23 "2021-10-20T18:15:21Z")
@Jeff_Hager Could you please clarify that? ---
**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, 1:53pm UTC](https://community.glideapps.com/t/how-to-search-compare-2-or-more-rows-with-data-in-different-tables/32473/24 "2021-10-21T13:53:19Z")
Anyone else thoughts? ---
**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 21, 2021, 3:27pm UTC](https://community.glideapps.com/t/how-to-search-compare-2-or-more-rows-with-data-in-different-tables/32473/25 "2021-10-21T15:27:46Z")
I’ll come back around to this. When questions require deeper thought from me, I need to find time to sit down, fire up my computer and give it my full attention. I have a day job and personal life that demands my attention sometimes. I’ll get back to this in a day or two. ---
**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, 4:53pm UTC](https://community.glideapps.com/t/how-to-search-compare-2-or-more-rows-with-data-in-different-tables/32473/26 "2021-10-21T16:53:45Z")
Sure, take your time. Just wanted to make sure it’s not forgotten. Thank you for your help. ---
**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")
@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. ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:50pm UTC](https://community.glideapps.com/t/how-to-search-compare-2-or-more-rows-with-data-in-different-tables/32473/28 "2024-01-17T16:50:01Z")
[Previous page](https://community.glideapps.com/t/how-to-search-compare-2-or-more-rows-with-data-in-different-tables/32473.md?page=1)