# Combine two product photos

**URL:** <https://community.glideapps.com/t/combine-two-product-photos/77973>\
**Category:** Ask for Help\
**Created:** [November 17, 2024, 3:00pm UTC](https://community.glideapps.com/t/combine-two-product-photos/77973 "2024-11-17T15:00:38Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\
**Post date:** [November 17, 2024, 3:00pm UTC](https://community.glideapps.com/t/combine-two-product-photos/77973/1 "2024-11-17T15:00:38Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/eb73edb9cb89c560e8516bab90475a5437bd9840.png)

I have 2 tables called product and variation, in the product table there is a product image and in product variation there is a product variation image which represents the image in the product table, for example I have a photo of a clothing product in the product table, and in product variation I have a photo of the product variation such as red, blue, black etc.

My question is, is there a way to combine the two product photo tables into one make array

---

<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:** [November 17, 2024, 3:19pm UTC](https://community.glideapps.com/t/combine-two-product-photos/77973/2 "2024-11-17T15:19:15Z")

</div>

You can add a Lookup column against the relation and then add a Make Array column to merge it with the product image.

---

<div class="post-metadata">

**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\
**Post date:** [November 17, 2024, 3:27pm UTC](https://community.glideapps.com/t/combine-two-product-photos/77973/3 "2024-11-17T15:27:58Z")

</div>

> [@Jeff\_Hager](#):
>
> Lookup column

if adding a lookup column doesn’t it just take the first one?  
whereas in my data, one product ID can have 4 to 5 product variations

---

<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:** [November 17, 2024, 3:37pm UTC](https://community.glideapps.com/t/combine-two-product-photos/77973/4 "2024-11-17T15:37:30Z")

</div>

Your relation is multiple, so the lookup will be multiple.

---

<div class="post-metadata">

**Author:** ![agung\_taufik1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik1/32/80541_2.png) [@agung\_taufik1](https://community.glideapps.com/u/agung_taufik1)\
**Post date:** [November 17, 2024, 3:49pm UTC](https://community.glideapps.com/t/combine-two-product-photos/77973/5 "2024-11-17T15:49:36Z")

</div>

great, I think it’s like lookup in excel which can only retrieve the first data, thanks Jeff

---

<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:** [November 24, 2024, 3:50pm UTC](https://community.glideapps.com/t/combine-two-product-photos/77973/6 "2024-11-24T15:50:22Z")

</div>

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