Hi All, Forgive what maybe a very simple question but I can not figure out how to create a many to many relationship between two tables. I have two tables - Tasks and Projects. Both are many to many relationship. Can i create a lookup column in each table or would I need to have two lookup colu…

Dear @Aaron_Westberg , Rather sure that his post gives you the right direction: [image] Reverse Lookup to Table Of course, you can do the one way table, which works just fine: [image] This is done like so: [image] [image]

Thanks for the response. I would also like the [Items Bought] column in the customers table to be a lookup to the [purchases] table and not using formula referance because formula referance is read only. So whether I add [items bought] to the customer table or add [customers] to the purchases t…

You’re welcome, Yes you are right, you could call it transaction table. I suggest to use a transaction ID where one or more customers can purchase one or more items on a repeatedly base. And accordingly you can make a summary table to get the data needed accordingly your business logic. Start wi…

Thanks again Jean, I am struggling with how to setup the table lookups and formulas. I have three tables ‘task’ ‘projects’ ‘link’ my transition table is the link table. How would i setup lookups between the tables so that I can add many tasks to one project and also add many projects to one t…

Dear @Aaron_Westberg , I hope that the below explains better how it works Feel free to play around and experience how the updates are immediately visible You can add as many projects and tasks as you require, no need for more tables

Thanks again Jean for all your help! This community is amazing :slight_smile: I see what you are doing with the example you shared with me but am still puzzled on how to add tasks to the all_task table directly and be able to select the related_project at the same time while adding a task. The …

Dear @Aaron_Westberg I have added buttons to add projects and tasks. I configured it in this way, so you can assign immediately the related tasks to the project.

Jean, Once again thank you for your help! This is not quite what I was after however. While in the all_projects table I want to be able to add tasks within all_projects using lookup function. This part is good and works. But then I also want to open up a individual task from all_tasks and a…

Dear @Aaron_Westberg , For the moment I don’t see a solution, maybe because I am not able to focus for this moment on the subject. Let’s see if @BenLee / @mallika or @anybody else is able to give a helping hand :handshake:

I believe the solution is using a third transaction table but I cant figure out how to set it up in coda.

Many to many lookups and keeping it all in sync question

Dalmo_Mendonca September 13, 2019, 9:46pm 12

Hi Aaron, I believe this scenario is quite similar to what you’re looking for:

Topic		Replies	Views
Many to many with lookup Product Feedback	4	1157	September 18, 2019
Connecting Lookup Tables via Join Row?	13	3241	February 21, 2020
Reverse Lookup to Table	9	2670	September 17, 2019
How To Make A "Mutual" Lookup	4	764	August 18, 2021
Simulating One To Many Relationship in Coda	4	1212	February 4, 2021

Many to many lookups and keeping it all in sync question

Related topics