Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

list all records mathing a condition in another linked table

Topic Labels: Data
544 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