Create Relation between local table and SQL data source

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.

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

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

Hi ThinhDinh,

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

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

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

1 Like