# Query Dilemma

**URL:** <https://community.glideapps.com/t/query-dilemma/2646>\
**Category:** Ask for Help\
**Created:** [December 5, 2019, 1:39pm UTC](https://community.glideapps.com/t/query-dilemma/2646 "2019-12-05T13:39:29Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lori\_W](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lori_w/32/876_2.png) [@Lori\_W](https://community.glideapps.com/u/Lori_W)\
**Post date:** [December 5, 2019, 1:39pm UTC](https://community.glideapps.com/t/query-dilemma/2646/1 "2019-12-05T13:39:29Z")

</div>

I have 2 tabs of concern in my app. The “Search by Subject” tab is to show all standards listed by subject PreK to 12 and will allow me to search. The “HS BY SUB” tab is to show an inline list of high school courses by subject, math, science, etc, that I can select and then select the particular course, say Calculus, these too are searchable at the course level.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/ea7be41d857a52fdf79cc82f00b6bf81fb77495d.png)  
I have a page in the data base that lists the subject areas: mathematics, social studies, etc. I have two queries built to do the work above, Qu\_Subject and qu\_hslist, respectively.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/2d54a763ba2f27ab271589eb214b1f713f38ab0b.png)

My problem: When I select the QU\_Subject query on the “Search by Subject” tab, which is what I want, this query is then copied in the “HS BY SUB” tab also. I can do the reverse and the selection I make on either tab is duplicated on both tabs. UGH.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f920131dcd584c27ccd1f5a9c324d6723119535d.png)  
What am I doing wrong? How do I get them to work independently?? TYIA

---

<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:** [December 5, 2019, 4:03pm UTC](https://community.glideapps.com/t/query-dilemma/2646/2 "2019-12-05T16:03:51Z")

</div>

Are both tabs using the same underlying sheet?

---

<div class="post-metadata">

**Author:** ![Lori\_W](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lori_w/32/876_2.png) [@Lori\_W](https://community.glideapps.com/u/Lori_W)\
**Post date:** [December 5, 2019, 4:06pm UTC](https://community.glideapps.com/t/query-dilemma/2646/3 "2019-12-05T16:06:35Z")

</div>

The sheet containing the subjects is the same but the queries on that sheet are linking to two different sheets.

---

<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:** [December 5, 2019, 4:36pm UTC](https://community.glideapps.com/t/query-dilemma/2646/4 "2019-12-05T16:36:13Z")

</div>

Ok, so I’m understanding that both tabs are pointing to the same sheet. Layouts are tied to sheets, so any changes you make to the details layout on one tab will be reflected on the other tab as well. I would suggest creating a separate sheet to split some of this up.

Also, how many users are you going to have? I can see a potential problem if multiple people are trying to search at the same time and the query in your sheet keeps refreshing. Would there be any advantage to just showing the separate sheets in a list and using Glide’s built in search?

---

<div class="post-metadata">

**Author:** ![Lori\_W](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lori_w/32/876_2.png) [@Lori\_W](https://community.glideapps.com/u/Lori_W)\
**Post date:** [December 5, 2019, 4:56pm UTC](https://community.glideapps.com/t/query-dilemma/2646/5 "2019-12-05T16:56:08Z")

</div>

Thanks for the info. I didn’t know the layouts were tied to sheets, that will save me some headaches moving forward.

I am using Glide’s build in search once the query runs and lists the line items. Is there a better way?? Always open to suggestions.

---

<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:** [December 8, 2019, 5:05pm UTC](https://community.glideapps.com/t/query-dilemma/2646/6 "2019-12-08T17:05:44Z")

</div>

Glide’s built in search is pretty good. It will look at every column on the related sheet, so you should be able to use it to find everything you need. I thought maybe you were trying to build your own search using the google sheet query and a text entry or something like that. That’s where it gets a little complicated.
