Let’s say I have two tables: Customers Products In products table I have a lookup field to customers for selecting which customers bought that product. Now, in customers table I want to see which products they have bought. How can I do that?

Do you have a sample document you can link? I wasn’t sure about several points, so I made some assumptions for this solution. My two tables look like this: [image] I setup the Purchasers column in the Products table as a Select List formatted column, and allowed for multiple selections and to u…

Thank you, @Joseph_B The solution you have provided is almost close to what I need. From the above solution, I want to select products bought from Customers table as well. For example: In Products Table, if I select, Kevin and Jane for Wrench Product then it should be automatically get updated a…

Got it. The approach I have for this makes some assumptions and might not be as clean as you want. Others may have alternate or better solutions. First, I updated the above tables by adding a row (screwdriver) to Products to highlight some of the changes, and added two columns to the Customers ta…

Thank you for the detailed response. However, I think it’ll be quite clumsy to work this way. I was looking for functionality similar to AirTable which by default allow to do what I am looking for.

Pawan_Agrawal, This is actually a really good question, and was valuable for me to put time into figuring out, so thank you for asking. I learned about one way to do it, but as of yet it does not seem to be bidirectional. What you’re looking for is this: [image] Where if you click on either the …

Of course, you can do the one way table, which works just fine: [image] This is done like so: [image] [image]

Hey CODA team, any insights about a “reverse lookup column” coming up in a next update of CODA ? Airtable has it at its core and it’s really powerful to have … as well as having the possibility not to have it too (like it is now). Ideally, both should be available. Don’t know if it’s technically p…

I have been struggling with many many relationships and I think the reverse lookup would solve everything! I too was using airtable and could keep it all in sync with many to many relationships but coda seems more limited this way. Does anyone know of a hack using automations to do this?

Hello everyone, You may want to consider this schema when working with this problem, thanks! [image] Many to many with lookup Suggestion Box Hello @Aaron_Westberg , Since this is currently not avaliable (and may never be given the complications of having such 2-way sync …

Reverse Lookup to Table

Bobby_Ritter September 17, 2019, 1:34pm 10

Hello everyone,

You may want to consider this schema when working with this problem, thanks!

Topic		Replies	Views
How To Make A "Mutual" Lookup	4	779	August 18, 2021
Many to many lookups and keeping it all in sync question	13	2600	April 6, 2020
Dynamic select list items based on a lookup column	4	4166	January 17, 2020
Combining 2 different Columns from 2 different tables in a Lookup	6	2286	May 10, 2020
Autofill Lookup Values. Automatically link rows from two different tables	4	1221	July 14, 2021

Reverse Lookup to Table

Related topics