# V look up

**URL:** <https://community.glideapps.com/t/v-look-up/78661>\
**Category:** Ask for Help\
**Created:** [December 17, 2024, 7:49pm UTC](https://community.glideapps.com/t/v-look-up/78661 "2024-12-17T19:49:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dibadawg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dibadawg/32/81767_2.png) [@Dibadawg](https://community.glideapps.com/u/Dibadawg)\
**Post date:** [December 17, 2024, 7:49pm UTC](https://community.glideapps.com/t/v-look-up/78661/1 "2024-12-17T19:49:11Z")

</div>

Hey guys.

so in order to understand what i am trying to do, i need to explain what i am building

I am building a portal for the members of a dog organization. I have a few datasheets that im working off but what i need help with is only related to 2 sheets. I am using a “helper” table in order to record and submit a form to our head office and i have a database of dogs with all they relevant information.

Currently, the owner of a stud male has to submit a mating certificate to the office. in my form that i have created, me as the stud dog owner, can select my dog from a drop down menu, after that, i have a bunch of text entry details for the details of the female.

My question is, on my helper sheet, i also require to bring in all the info about the male, for example, registration number, microchip number, working qualifications. i have all this data in my dog datasheet but i would like to automatically bring it into my helper sheet by simply selecting the name of the dog from my drop down menu. is there a way to do it without it showing on the mating certificate form?

---

<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:** [December 17, 2024, 8:05pm UTC](https://community.glideapps.com/t/v-look-up/78661/2 "2024-12-17T20:05:30Z")

</div>

Create a Relation column in your helper table, followed by as many Lookup columns as you need to return all of the information from the relation.

---

<div class="post-metadata">

**Author:** ![Dibadawg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dibadawg/32/81767_2.png) [@Dibadawg](https://community.glideapps.com/u/Dibadawg)\
**Post date:** [December 17, 2024, 8:09pm UTC](https://community.glideapps.com/t/v-look-up/78661/3 "2024-12-17T20:09:35Z")

</div>

so i have 25 columns of data per each dog, is it possible to only pull 5 specific columns for example

---

<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:** [December 17, 2024, 8:26pm UTC](https://community.glideapps.com/t/v-look-up/78661/4 "2024-12-17T20:26:23Z")

</div>

Yes. Create a Relation and 5 Lookup columns.

---

<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:** [December 24, 2024, 8:26pm UTC](https://community.glideapps.com/t/v-look-up/78661/5 "2024-12-24T20:26:58Z")

</div>

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