# Connect Table to another

**URL:** <https://community.glideapps.com/t/connect-table-to-another/67517>\
**Category:** Ask for Help\
**Created:** [November 3, 2023, 5:31pm UTC](https://community.glideapps.com/t/connect-table-to-another/67517 "2023-11-03T17:31:26Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Emil\_Tevatrosyan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emil_tevatrosyan/32/65955_2.png) [@Emil\_Tevatrosyan](https://community.glideapps.com/u/Emil_Tevatrosyan)\
**Post date:** [November 3, 2023, 5:31pm UTC](https://community.glideapps.com/t/connect-table-to-another/67517/1 "2023-11-03T17:31:26Z")

</div>

Hi Glide brothers

I want to ask one question related to connecting 2 tables data.

In this example user will add client to the app with the form that will also have file picker in it.

questions:

1.How I can structure tables that way so that client can have multiple documents attached.

1. How to structure tables that way so that each document have its own folder : (agreement doc on agreements folder, rules doc on rules folder)

2. Must I add somehting o the table if I will let user to add missing docs later.

Thanks in advance guys

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [November 3, 2023, 11:40pm UTC](https://community.glideapps.com/t/connect-table-to-another/67517/2 "2023-11-03T23:40:55Z")

</div>

You should have 3 tables.

**Users**

| RowID | Email | Name |
| --- | --- | --- |
| a123 | [a@example.com](mailto:a@example.com) | Andy |
| b123 | [b@example.com](mailto:b@example.com) | Betty |

**Folders**

| RowID | UserID | Folder Name |
| --- | --- | --- |
| fa123 | a123 | Andy’s Agreement |
| fb123 | b123 | Betty’s Rules |

**Files**

| RowID | FolderID | File Name | File URL |
| --- | --- | --- | --- |
| fia123 | fa123 | Agreement 1 | [https://example.com/](https://example.com/) |
| fib123 | fa123 | Agreement 2 | [https://example.com/](https://example.com/) |

The structure above means Andy will have a folder named Andy’s Agreement with 2 files: Agreement 1 & Agreement 2.

Betty will have a folder named Betty’s Rules with no files.

---

<div class="post-metadata">

**Author:** ![Emil\_Tevatrosyan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emil_tevatrosyan/32/65955_2.png) [@Emil\_Tevatrosyan](https://community.glideapps.com/u/Emil_Tevatrosyan)\
**Post date:** [November 4, 2023, 4:34am UTC](https://community.glideapps.com/t/connect-table-to-another/67517/3 "2023-11-04T04:34:57Z")

</div>

Great! Thank you very much!

Will that folder ID be created automatically, when adding files from app.

Is there any way to use multiple file picker and how to structure data in that case?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [November 4, 2023, 8:12am UTC](https://community.glideapps.com/t/connect-table-to-another/67517/4 "2023-11-04T08:12:53Z")

</div>

The FolderID is the rowID from the Folders table. It will be automatically created when you create a new folder, and when you add a file, make sure you use special values component to pass the folderID to the Files row.

For multiple files, do you want them to ultimately be on its own row in the Files folder, or a multiple file column in there will be ok as well?

---

<div class="post-metadata">

**Author:** ![Emil\_Tevatrosyan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emil_tevatrosyan/32/65955_2.png) [@Emil\_Tevatrosyan](https://community.glideapps.com/u/Emil_Tevatrosyan)\
**Post date:** [November 4, 2023, 11:26am UTC](https://community.glideapps.com/t/connect-table-to-another/67517/5 "2023-11-04T11:26:41Z")

</div>

great!

Two cases will work, just thinking that it will be more convenient to have it on the same row.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [November 5, 2023, 12:32am UTC](https://community.glideapps.com/t/connect-table-to-another/67517/6 "2023-11-05T00:32:19Z")

</div>

Then I think your File form can utilize a multiple file component, and write it to a multiple file column on the Files table.