# Collecting additional column data

**URL:** <https://community.glideapps.com/t/collecting-additional-column-data/73282>\
**Category:** Ask for Help\
**Created:** [May 12, 2024, 5:39am UTC](https://community.glideapps.com/t/collecting-additional-column-data/73282 "2024-05-12T05:39:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![barneylodge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/barneylodge/32/70676_2.png) [@barneylodge](https://community.glideapps.com/u/barneylodge)\
**Post date:** [May 12, 2024, 5:39am UTC](https://community.glideapps.com/t/collecting-additional-column-data/73282/1 "2024-05-12T05:39:53Z")

</div>

When placing an order, my customers may have more than one delivery address, and are able to add guidance to drivers for each delivery address.

When adding an order (to the orders table), they choose which delivery address using the choice component. How can the order also include the driver guidance associated with that address.

---

<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:** [May 12, 2024, 8:17am UTC](https://community.glideapps.com/t/collecting-additional-column-data/73282/2 "2024-05-12T08:17:23Z")

</div>

Let’s assume that you store the Delivery Addresses in their own table (if you don’t, you should).

Let’s further assume that you have the following columns in that table:

- RowID
- CustomerID
- Address
- Instructions

When a customer selects a delivery address, you should be saving the associated RowID. You can then use that to create a single relation to the Delivery Addresses table, and then use a Lookup column to fetch the associated Instructions for that address.

---

<div class="post-metadata">

**Author:** ![barneylodge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/barneylodge/32/70676_2.png) [@barneylodge](https://community.glideapps.com/u/barneylodge)\
**Post date:** [May 12, 2024, 8:58am UTC](https://community.glideapps.com/t/collecting-additional-column-data/73282/3 "2024-05-12T08:58:29Z")

</div>

Brilliant…will take a look

---

<div class="post-metadata">

**Author:** ![barneylodge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/barneylodge/32/70676_2.png) [@barneylodge](https://community.glideapps.com/u/barneylodge)\
**Post date:** [May 12, 2024, 5:39pm UTC](https://community.glideapps.com/t/collecting-additional-column-data/73282/4 "2024-05-12T17:39:00Z")

</div>

It’s working now. Very very grateful

Barney

---

<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 19, 2024, 5:39pm UTC](https://community.glideapps.com/t/collecting-additional-column-data/73282/5 "2024-05-19T17:39:12Z")

</div>

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