# Relationship of transaction history related to type of currency and person

**URL:** <https://community.glideapps.com/t/relationship-of-transaction-history-related-to-type-of-currency-and-person/7844>\
**Category:** Ask for Help\
**Created:** [April 25, 2020, 11:15pm UTC](https://community.glideapps.com/t/relationship-of-transaction-history-related-to-type-of-currency-and-person/7844 "2020-04-25T23:15:14Z")\
**Posts on this page:** 5\
**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:** [April 25, 2020, 11:15pm UTC](https://community.glideapps.com/t/relationship-of-transaction-history-related-to-type-of-currency-and-person/7844/1 "2020-04-25T23:15:15Z")

</div>

Hello, help please!!  
I’m making a relationship where an account has several types of currencies (USD; Euros, Yen, etc) (1:M) and each currency has historical movements. The relationship to present the movements by currency doing a search entering the account to see which currencies have already achieved, but once I access the currency I can not see their historical movements. What type of relationship should I generate in this case?

I have 4 tables, the people table, the currency table, the portfolio table (where I relate people and currencies) and the historical table

In the history table I am storing the ID of the person and the currency, with the data of the transaction, date and amount

as you can see in the image, when I select the coin I get the data of all the coins, not the one that corresponds ☹

 ![problema](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c109ee75a4a279b58e687afcbdf579163fc42139.png)  
Thanks for your support

---

<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:** [April 26, 2020, 11:40pm UTC](https://community.glideapps.com/t/relationship-of-transaction-history-related-to-type-of-currency-and-person/7844/2 "2020-04-26T23:40:45Z")

</div>

I already solved the problem using unique identifiers , now, the problem I have is that when I want to register a new currency, I use a selection box but the value it brings me is not the unique identifier but the text that the user sees from the existing moneys!How can I make it so that it brings me the value of the unique identifier and not the text? Thank you very much.

---

<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:** [April 28, 2020, 1:07am UTC](https://community.glideapps.com/t/relationship-of-transaction-history-related-to-type-of-currency-and-person/7844/3 "2020-04-28T01:07:04Z")

</div>

Unfortunately, that is one big thing missing from the choice component. It’s been requested before, but you can add your case the the feature requests.

> [@Assign to object](https://community.glideapps.com/t/assign-to-object/6579/2):
>
> Exactly what you want has been suggested already but to date not implemented. Go into. Search for “Choice Component - allow key display pairs” and vote for it in [https://features.staging.glideapp.io/](https://features.staging.glideapp.io/)

---

<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:** [April 28, 2020, 1:30am UTC](https://community.glideapps.com/t/relationship-of-transaction-history-related-to-type-of-currency-and-person/7844/4 "2020-04-28T01:30:02Z")

</div>

I didn’t find that concept - allow key display pairs - in the wish list. ☹

---

<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:** [April 28, 2020, 1:35am UTC](https://community.glideapps.com/t/relationship-of-transaction-history-related-to-type-of-currency-and-person/7844/5 "2020-04-28T01:35:38Z")

</div>

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