Connecting new entries to existing entry in another table

[Carolie_Delisle]

I have 2 tables that I need to interact together based on 2 criteria.

Table Interaction (will occur throughout the year)
Contains Name of person contacted and Project the discussion was about.

When I create a new Contract (table Contract), I will assign these same Names and Projects to the new contract and would like the Interaction from “Table Interaction” to automatically connect based on the Name and Project criteria.

I am able to connect the 2 tables but in the but I can’t have it properly filtered by both Name and Project, It works for Projects then Names. Even if I do an AND…

I tried creating a control, a unique reference name that are recurring in both tables, but to no avail…

Help? Thanks

[Carolie_Delisle]

With the Unique references…

[Carolie_Delisle]

Here I almost got it, but it’s showing all the interactions from an artist without filtering out the project component. As it is a Relation Column, I can’t seem to add another filter criteria.

[Pablo_DV]

Hi Carolie,

Welcome to the community!

You were in the right direction, but since you want to use 2 criterias you can’t not configure it only through the UI.

If you press the f button, what you have configured through the UI will be turned into a formula, which then you can extend for your purposes.

In this case, the formula would need to be something like this. (I’m not sure because you didn’t share much of your Interactions table)

[Interactions].filter(Artiste=thisRow.Artiste AND Projet=thisRow.Projet)

Hope this helps,

Pablo

[Carolie_Delisle]

@Pablo_DV

[Interactions].filter(Artiste=thisRow.Artiste AND Projet=thisRow.Projet)

Works flawlessly ! Thank your kindly Pablo !