# How can I make available a lookup

**URL:** <https://community.glideapps.com/t/how-can-i-make-available-a-lookup/24557>\
**Category:** Ask for Help\
**Created:** [March 21, 2021, 4:20pm UTC](https://community.glideapps.com/t/how-can-i-make-available-a-lookup/24557 "2021-03-21T16:20:54Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![22c304](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/22c304/32/19733_2.png) [@22c304](https://community.glideapps.com/u/22c304)\
**Post date:** [March 21, 2021, 4:20pm UTC](https://community.glideapps.com/t/how-can-i-make-available-a-lookup/24557/1 "2021-03-21T16:20:54Z")

</div>

Hello all  
I have a lookup defined that brings back individual materials from a glide table into my work orders glide table via relation. I would like these items to be available to a template column so i could email them.  
I am having trouble figuring out how to make that lookup available.  
TIA  
Wes

 ![WO Materials](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/1/71c33f7ace70975a098192bef654da2dcf2b226b.png)

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [March 21, 2021, 5:31pm UTC](https://community.glideapps.com/t/how-can-i-make-available-a-lookup/24557/2 "2021-03-21T17:31:27Z")

</div>

Hola @22c304,

It looks like you are using a multiple relaxation for this. They a single relation.

Now if you need to use all those results, it is better to use a joint list column.

---

<div class="post-metadata">

**Author:** ![22c304](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/22c304/32/19733_2.png) [@22c304](https://community.glideapps.com/u/22c304)\
**Post date:** [March 21, 2021, 6:14pm UTC](https://community.glideapps.com/t/how-can-i-make-available-a-lookup/24557/3 "2021-03-21T18:14:09Z")

</div>

Thanks @SantiagoPerez  
Yes I am bringing them back through a multi relation (as they are details of the work order).  
I tried a joined list but was unable to make it work as i only want the details brought back for a specific work order and I was bringing back everything.  
I want to use the list as shown in the pic so i can email it.  
How would i set up the joined list to only bring back the items for a specific work order?  
TIA

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [March 21, 2021, 7:26pm UTC](https://community.glideapps.com/t/how-can-i-make-available-a-lookup/24557/4 "2021-03-21T19:26:59Z")

</div>

@22c304, you need to get the joined list from that same relation. Just like you did with the lookup but using a joined list column.

---

<div class="post-metadata">

**Author:** ![22c304](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/22c304/32/19733_2.png) [@22c304](https://community.glideapps.com/u/22c304)\
**Post date:** [March 21, 2021, 8:53pm UTC](https://community.glideapps.com/t/how-can-i-make-available-a-lookup/24557/5 "2021-03-21T20:53:11Z")

</div>

@SantiagoPerez  
Took me a while, but i was able to figure it out.  
Gracias …

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [March 21, 2021, 9:00pm UTC](https://community.glideapps.com/t/how-can-i-make-available-a-lookup/24557/6 "2021-03-21T21:00:01Z")

</div>

No hay de que. @22c304