# Lookup Latest Row (idea for lookups with Multiple Relations)

**URL:** <https://community.glideapps.com/t/lookup-latest-row-idea-for-lookups-with-multiple-relations/12441>\
**Category:** Feature Requests\
**Created:** [July 14, 2020, 12:28am UTC](https://community.glideapps.com/t/lookup-latest-row-idea-for-lookups-with-multiple-relations/12441 "2020-07-14T00:28:22Z")\
**Posts on this page:** 1\
**Showing post:** 5

<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:** [July 14, 2020, 12:21pm UTC](https://community.glideapps.com/t/lookup-latest-row-idea-for-lookups-with-multiple-relations/12441/5 "2020-07-14T12:21:51Z")

</div>

This is multiple steps, but you can do a rollup on your relation to get a max date for example, build a template with the rollup date and whatever you used for your previous relation in the sheet containing the relation and The sheet you are relating to. Then create a new single relation using the template to get only the last record. It’s a lot of Glide columns, but it’s better than a completely separate sheet and duplicated data.

---

_[View the full topic](https://community.glideapps.com/t/lookup-latest-row-idea-for-lookups-with-multiple-relations/12441)._