Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Filter multiple tables and columns

Hi I have the following problem

i need the name of the customer

 

in Table Omission i want to create a column Name Project which shows the name of customer that is related to Project_id from table omiission

the formula needs to be like this:

If Omission Table (project_id)-->Project Table(project_end_customer_id)-->Table project_end_customer_id(id)-->Table Customer(id) is a match give me Table Customer(Name) as the result

in the photo is how the relationships are between the different tables and 

 

 

kind regards 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi i have difficulties with looking up a value over multiple tables

    I want to add a column in table Omission with the customer name from Table Customer

    please see photo below for the relationships

    P