# Relation/lookup value DESC

**URL:** <https://community.glideapps.com/t/relation-lookup-value-desc/60643>\
**Category:** Ask for Help\
**Created:** [April 17, 2023, 8:10pm UTC](https://community.glideapps.com/t/relation-lookup-value-desc/60643 "2023-04-17T20:10:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![GK123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gk123/32/40613_2.png) [@GK123](https://community.glideapps.com/u/GK123)\
**Post date:** [April 17, 2023, 8:10pm UTC](https://community.glideapps.com/t/relation-lookup-value-desc/60643/1 "2023-04-17T20:10:58Z")

</div>

I have two tables:

1. user  
2)purchases.

For each purchase, there are many columns but two of them are the most relevant:  
1)email of the user  
2) a unique link

I want to add a column in the user table that will automatically be filed by the LAST (newest) link of the purchase for each user.

So for example, Bob bought a book. So I will have a new row in the purchase table with Bob’s email and a unique link and date of purchase.  
Now I need to find a way that will copy the link to the column in the user table that calls (for example) “last link of purchase”

It’s not a regular relation, because I need to have the relation on the newest row.

How can I do it? What am I missing?

---

<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 17, 2023, 8:58pm UTC](https://community.glideapps.com/t/relation-lookup-value-desc/60643/2 "2023-04-17T20:58:53Z")

</div>

Create a multiple relation linking the email in the user table to the email in the purchase table. Then create a Single Value column that retrieves the last link from the relation.