# Create Relation between local table and SQL data source

**URL:** <https://community.glideapps.com/t/create-relation-between-local-table-and-sql-data-source/76661>\
**Category:** Ask for Help\
**Created:** [September 27, 2024, 7:27am UTC](https://community.glideapps.com/t/create-relation-between-local-table-and-sql-data-source/76661 "2024-09-27T07:27:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![RD.ai](https://avatars.discourse-cdn.com/v4/letter/r/4bbf92/32.png) [@RD.ai](https://community.glideapps.com/u/RD.ai)\
**Post date:** [September 27, 2024, 7:27am UTC](https://community.glideapps.com/t/create-relation-between-local-table-and-sql-data-source/76661/1 "2024-09-27T07:27:47Z")

</div>

Hi,

I get an error “This column cannot be saved” when create a relation between local table(user choice selection) with external SQL table(task records). I created “Today” , “This week” and “This month” choice for user to select. The task collection will display related records based on user choice.  
Please assist. Thank you.

 ![This column cannot be saved error](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/2/429ee69351818736ab5dd14a5497b2233bb3a757.jpeg)

 ![User choice selection](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/6/762a895d128bf43c893eded147e927f181da8e63.jpeg)

---

<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:** [September 28, 2024, 2:49am UTC](https://community.glideapps.com/t/create-relation-between-local-table-and-sql-data-source/76661/2 "2024-09-28T02:49:45Z")

</div>

It’s a known Big Tables limitation, but can you try enabling this to see if it helps?

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

Otherwise you must find another way to work with that type of data.

---

<div class="post-metadata">

**Author:** ![RD.ai](https://avatars.discourse-cdn.com/v4/letter/r/4bbf92/32.png) [@RD.ai](https://community.glideapps.com/u/RD.ai)\
**Post date:** [October 1, 2024, 5:22am UTC](https://community.glideapps.com/t/create-relation-between-local-table-and-sql-data-source/76661/3 "2024-10-01T05:22:34Z")

</div>

Hi ThinhDinh,

Thanks for your reply. I have found a solution for the issue.

---

<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:** [October 1, 2024, 1:52pm UTC](https://community.glideapps.com/t/create-relation-between-local-table-and-sql-data-source/76661/4 "2024-10-01T13:52:04Z")

</div>

Can you share what your solution is so people who read this later can know? Thank you.

---

<div class="post-metadata">

**Author:** ![RD.ai](https://avatars.discourse-cdn.com/v4/letter/r/4bbf92/32.png) [@RD.ai](https://community.glideapps.com/u/RD.ai)\
**Post date:** [October 2, 2024, 1:37am UTC](https://community.glideapps.com/t/create-relation-between-local-table-and-sql-data-source/76661/5 "2024-10-02T01:37:01Z")

</div>

Instead of using relation, I created a table by using custom query.