# Adding all the rows in my product table to my orders table

**URL:** <https://community.glideapps.com/t/adding-all-the-rows-in-my-product-table-to-my-orders-table/69213>\
**Category:** Ask for Help\
**Created:** [January 3, 2024, 7:01pm UTC](https://community.glideapps.com/t/adding-all-the-rows-in-my-product-table-to-my-orders-table/69213 "2024-01-03T19:01:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jankeyser](https://avatars.discourse-cdn.com/v4/letter/j/f04885/32.png) [@jankeyser](https://community.glideapps.com/u/jankeyser)\
**Post date:** [January 3, 2024, 7:01pm UTC](https://community.glideapps.com/t/adding-all-the-rows-in-my-product-table-to-my-orders-table/69213/1 "2024-01-03T19:01:27Z")

</div>

Hey Gliders Guys,

Can someone help me with this little bit?

I have an order form where a customer fills in details and then chooses a product from a dropdown that is sourced from my Price List Table.

How do I get the complete product with all columns including price to pull into the orders table once order is submitted?

Thanks alot for all the help so far.  
Great Community

---

<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:** [January 3, 2024, 7:36pm UTC](https://community.glideapps.com/t/adding-all-the-rows-in-my-product-table-to-my-orders-table/69213/2 "2024-01-03T19:36:51Z")

</div>

Assuming you are writing a Product ID to the order table, you can use it in a Relation column to link to the Price List table and then add Lookup columns to retrieve the values you want from the price table through the relation.

---

<div class="post-metadata">

**Author:** ![jankeyser](https://avatars.discourse-cdn.com/v4/letter/j/f04885/32.png) [@jankeyser](https://community.glideapps.com/u/jankeyser)\
**Post date:** [January 4, 2024, 8:20am UTC](https://community.glideapps.com/t/adding-all-the-rows-in-my-product-table-to-my-orders-table/69213/3 "2024-01-04T08:20:55Z")

</div>

Thanks Jeff  
I had some figuring out to do there, but I won.

---

<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:** [January 11, 2024, 8:21am UTC](https://community.glideapps.com/t/adding-all-the-rows-in-my-product-table-to-my-orders-table/69213/4 "2024-01-11T08:21:05Z")

</div>

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