Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

list all records mathing a condition in another linked table

Topic Labels: Data
394 0
cancel
Showing results for 
Search instead for 
Did you mean: 
simonmaster
4 - Data Explorer
4 - Data Explorer

Hi to all,

This is my question:

I have a table "table#1" whith a list of records. In this table i have a colum named "project" of type Link with 'allow multiple link', linked to another table "Table#2" with a list of project.

In another table "Table#3" I have the same column, named "project", of type Link with 'allow multiple link', linked to the table "Table#2".

In "Table#3" I want to create a field to collect and list all the related records in "Table#1" that match this condition: The value of column "project" (in Table#3) is equal to the value of column "project" in "Table#2".

Is there a way to do this with a formula?

Many thanks.

0 Replies 0