# Referencing different table based on QR scans

**URL:** <https://community.glideapps.com/t/referencing-different-table-based-on-qr-scans/62641>\
**Category:** Ask for Help\
**Created:** [June 11, 2023, 8:00am UTC](https://community.glideapps.com/t/referencing-different-table-based-on-qr-scans/62641 "2023-06-11T08:00:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![as1said](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/as1said/32/60137_2.png) [@as1said](https://community.glideapps.com/u/as1said)\
**Post date:** [June 11, 2023, 8:00am UTC](https://community.glideapps.com/t/referencing-different-table-based-on-qr-scans/62641/1 "2023-06-11T08:00:46Z")

</div>

Hi,

Is it possible for me to reference different table based on QR scan input?

In my inventory tables (raw, wip, finished), i have created a QR for each items based on a template column “raw, ID”, “WIP, ID” and “finished, ID”.

I’d like to scan that QR from one form and it can lookup the item automatically whether it is raw, wip or finished product.

I have created a table that extract the text from the QR and split the required ID. But how do I reference the relevant table?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 11, 2023, 8:20am UTC](https://community.glideapps.com/t/referencing-different-table-based-on-qr-scans/62641/2 "2023-06-11T08:20:32Z")

</div>

You should be able to use a relation + lookup.

---

<div class="post-metadata">

**Author:** ![as1said](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/as1said/32/60137_2.png) [@as1said](https://community.glideapps.com/u/as1said)\
**Post date:** [June 12, 2023, 12:14am UTC](https://community.glideapps.com/t/referencing-different-table-based-on-qr-scans/62641/3 "2023-06-12T00:14:09Z")

</div>

Do you mean that I would need to create 3 relations and 3 lookup columns to all 3 tables?

---

<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:** [June 12, 2023, 2:56am UTC](https://community.glideapps.com/t/referencing-different-table-based-on-qr-scans/62641/4 "2023-06-12T02:56:56Z")

</div>

If there are 3 different tables involved, then yes, you will need 3 relations. One for each table. Along with 3 Lookup columns, you can then have an IF column to return the lookup column value that is not empty.

---

<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:** [June 13, 2023, 2:57am UTC](https://community.glideapps.com/t/referencing-different-table-based-on-qr-scans/62641/5 "2023-06-13T02:57:23Z")

</div>

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