# Autofill or Look up from another table

**URL:** <https://community.glideapps.com/t/autofill-or-look-up-from-another-table/41697>\
**Category:** Ask for Help\
**Created:** [May 6, 2022, 3:20pm UTC](https://community.glideapps.com/t/autofill-or-look-up-from-another-table/41697 "2022-05-06T15:20:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chichap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chichap/32/42361_2.png) [@Chichap](https://community.glideapps.com/u/Chichap)\
**Post date:** [May 6, 2022, 3:20pm UTC](https://community.glideapps.com/t/autofill-or-look-up-from-another-table/41697/1 "2022-05-06T15:20:20Z")

</div>

Greetings, Im new in Glide.

I have A customer list (table) and Product list(table). Now in the Product form I want to have a dropdown list to get the customer name from customer list. I know its simple but I cant find the right direction or workaround.

Cheers!

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [May 6, 2022, 3:25pm UTC](https://community.glideapps.com/t/autofill-or-look-up-from-another-table/41697/2 "2022-05-06T15:25:51Z")

</div>

Hi @Chichap,

Welcome to the community 🥳

You can add the Choice Component to the form and connect the Customers table and you need a column in the Product table to write the selected customer for that product! You can add that column to the **Write to section** in the Choice component! And you can select the name for the **value** and **display** sections!

Docs for Choice component :

> **[Choice](https://docs.glideapps.com/all/topics/components/pickers/choice)**
>
> Pick one value among many

Thank you

---

<div class="post-metadata">

**Author:** ![Chichap](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chichap/32/42361_2.png) [@Chichap](https://community.glideapps.com/u/Chichap)\
**Post date:** [May 6, 2022, 3:34pm UTC](https://community.glideapps.com/t/autofill-or-look-up-from-another-table/41697/3 "2022-05-06T15:34:01Z")

</div>

> [@Dilon\_Perera](#):
>
> u can add the Choice Component to the form and connect the list

wow than you for your warm welcome and providing the guidance.  
appreciate it much! 🥰

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [May 7, 2022, 3:34pm UTC](https://community.glideapps.com/t/autofill-or-look-up-from-another-table/41697/4 "2022-05-07T15:34:03Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.