# Sync Connections between two tables

**URL:** <https://forums.knack.com/t/sync-connections-between-two-tables/14783>\
**Category:** Get Answers\
**Created:** [August 27, 2023, 7:48pm UTC](https://forums.knack.com/t/sync-connections-between-two-tables/14783 "2023-08-27T19:48:51Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Francois](https://avatars.discourse-cdn.com/v4/letter/f/77aa72/32.png) [@Francois](https://forums.knack.com/u/Francois)\
**Post date:** [August 27, 2023, 7:48pm UTC](https://forums.knack.com/t/sync-connections-between-two-tables/14783/1 "2023-08-27T19:48:51Z")

</div>

Hello

I have the following “problem” :

- Table A, Project list  
Has a many-to-many connections to the account table used to define who is part of the project  
Has a list of tasks = a connection to Table B

- Table B, Tasks list  
Has a many-to-one connection to the account table : each task is affected to an account

I want to display each project to accounts who are part of the project (so connections defined in Table A),  
BUT I also want to give acces to the project to accounts who are in charge of a task which is part of the project.

My idea would be to update account connection in Table A in accordance with task owners set up in Table B, and them filter the view on project list based on this connection.

I do not have a solution to do that in Knack, I am about to create a scenario in [Make.com](http://Make.com) to do it ; before doing so (should be avoided if possible), I am asking the community if a more clever solution could be found.

Thanks for your advices

---

<div class="post-metadata">

**Author:** ![Laurent](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/laurent/32/2855_2.png) [@Laurent](https://forums.knack.com/u/Laurent)\
**Post date:** [August 28, 2023, 3:58pm UTC](https://forums.knack.com/t/sync-connections-between-two-tables/14783/2 "2023-08-28T15:58:24Z")

</div>

Couldn’t you just put a dummy task “Is assigned to the project” automatically selected when a person is part of a project, and then only work with tasks, for instance display the Projects people have a task in (which include both task-people and higher ups)?

---

<div class="post-metadata">

**Author:** ![Francois](https://avatars.discourse-cdn.com/v4/letter/f/77aa72/32.png) [@Francois](https://forums.knack.com/u/Francois)\
**Post date:** [August 28, 2023, 7:42pm UTC](https://forums.knack.com/t/sync-connections-between-two-tables/14783/3 "2023-08-28T19:42:33Z")

</div>

Hello Laurent

Thank you for your help.  
Could you please provide more details regarding this solution ? I am sorry but I am not sure I have it.

My goal is to have “automatically” selected all persons having a task OR involved in the project.

Thanks

---

<div class="post-metadata">

**Author:** ![Patrick5](https://avatars.discourse-cdn.com/v4/letter/p/5f9b8f/32.png) [@Patrick5](https://forums.knack.com/u/Patrick5)\
**Post date:** [September 1, 2023, 9:17pm UTC](https://forums.knack.com/t/sync-connections-between-two-tables/14783/4 "2023-09-01T21:17:10Z")

</div>

> [@Francois](#):
>
> My goal is to have “automatically” selected all persons having a task OR involved in the project.

I do this a lot too, where I set permissions to a record based on multiple fields in other connected tables. All I’ve come up with is to make a special field with a many connection to accounts, and then I sync it with a Make scenario. It’s not a great solution because I have to remember to trigger the Make scenario for lots of different changes in the other tables. So I’ll be curious to see if you come up with a non-Make solution.

---

<div class="post-metadata">

**Author:** ![Francois](https://avatars.discourse-cdn.com/v4/letter/f/77aa72/32.png) [@Francois](https://forums.knack.com/u/Francois)\
**Post date:** [September 2, 2023, 7:09am UTC](https://forums.knack.com/t/sync-connections-between-two-tables/14783/5 "2023-09-02T07:09:25Z")

</div>

Hello Patrick

I did not manage to obtain my first idea so I changed it !  
I display projects in two separate grids, it is actually better for my case.

![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/f/fca9e0d5f826cce12e149c0a429db65c281551ea.png)

![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/7/7f5f7208e39d4df29b87678bdcd70357a8484610.png)

Have a good day