# Pay Button - Relation Question
**URL:** https://community.glideapps.com/t/pay-button-relation-question/15345
**Category:** Ask for Help
**Created:** [September 6, 2020, 1:20am UTC](https://community.glideapps.com/t/pay-button-relation-question/15345 "2020-09-06T01:20:53Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@\_eric](https://community.glideapps.com/u/_eric)
#### Post date: [September 6, 2020, 1:20am UTC](https://community.glideapps.com/t/pay-button-relation-question/15345/1 "2020-09-06T01:20:53Z")
How can I relate past payments back to other records?
There is an App:Sales tab in my Google Sheet but the tab is not accessible in glide and I am unable to relate that payment back to the parent record.
Does anyone have a solution?
---
### Author:  [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [September 6, 2020, 1:22am UTC](https://community.glideapps.com/t/pay-button-relation-question/15345/2 "2020-09-06T01:22:31Z")
If you just need the App: Sales values, just create a new sheet and use an Arrayformula for to pull in all its values. That new sheet will be accessible in Glide and you’ll be able to use it for relations.
---
### Author:  [@\_eric](https://community.glideapps.com/u/_eric)
#### Post date: [September 6, 2020, 1:23am UTC](https://community.glideapps.com/t/pay-button-relation-question/15345/3 "2020-09-06T01:23:43Z")
Do you know the array formula for that? That is exactly what I am looking for…
---
### Author:  [@\_eric](https://community.glideapps.com/u/_eric)
#### Post date: [September 6, 2020, 1:38am UTC](https://community.glideapps.com/t/pay-button-relation-question/15345/4 "2020-09-06T01:38:07Z")
Figured it out:
=QUERY(‘App: Sales’!A:N)
---
### Author:  [@Roberto\_Salim](https://community.glideapps.com/u/Roberto_Salim)
#### Post date: [September 6, 2020, 6:44pm UTC](https://community.glideapps.com/t/pay-button-relation-question/15345/5 "2020-09-06T18:44:30Z")
> [@\_eric](#):
>
> QUERY
That’s right, that’s what I did, and if I remember correctly the second column “Pus … Item” and renamed it with the same name in my product guide and created a list of them, with that to create visibility based on payment 😉
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 7, 2020, 2:48am UTC](https://community.glideapps.com/t/pay-button-relation-question/15345/6 "2020-09-07T02:48:39Z")
You should not need the query, albeit it’s an alternative, it should be just:
```
={'App: Sales’!A:N'}
```