# Update a field according to the selected value to go to the detail

**URL:** https://community.glideapps.com/t/update-a-field-according-to-the-selected-value-to-go-to-the-detail/8830
**Category:** Ask for Help
**Created:** [May 10, 2020, 12:52am UTC](https://community.glideapps.com/t/update-a-field-according-to-the-selected-value-to-go-to-the-detail/8830 "2020-05-10T00:52:09Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Juan\_Gutierrez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/juan_gutierrez/32/692_2.png) [@Juan\_Gutierrez](https://community.glideapps.com/u/Juan_Gutierrez)
#### Post date: [May 10, 2020, 12:52am UTC](https://community.glideapps.com/t/update-a-field-according-to-the-selected-value-to-go-to-the-detail/8830/1 "2020-05-10T00:52:10Z")

</div>

I have a tab that’s generated from a Query. This query brings up the summation of the transactions.I want to put the graph on the same screen where it shows the composition of the total balance, that information is on another sheet and is obtained with another query. The relationship between tables is done, but for the query where the graph comes from depends on the value selected. Next image is with the value entered manualy

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

Is it possible to detect which option was selected on the screen to pass that value to the cell from which the query that obtains the detail is controlled?

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

Many thanks for you help

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 10, 2020, 1:34am UTC](https://community.glideapps.com/t/update-a-field-according-to-the-selected-value-to-go-to-the-detail/8830/2 "2020-05-10T01:34:50Z")

</div>

Hi Juan, sorry if I got it wrong, but can’t you just setup a choice component containing all the options available, then pass that value to the cell you want?

---

<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: [May 10, 2020, 5:54pm UTC](https://community.glideapps.com/t/update-a-field-according-to-the-selected-value-to-go-to-the-detail/8830/3 "2020-05-10T17:54:25Z")

</div>

Can you show a little more information? Are you building your second query dynamically based on a selected value in the app? If so, that’s not going to work very well. You should be able to do this with relations/lookups/rollups and no queries at all, but it’s hard to tell without seeing more of your data layout.