Forum Discussion

marabeda's avatar
marabeda
Icon for Helper I rankHelper I
4 years ago
Solved

Create a calculated columns from 2 tables

Dear Community, I have these 2 tables: Table1 Table2 The relationship between tables is many-to-many with column Client My objective is to have two calculated columns in Table1 where ...
marabeda's avatar
marabeda
Icon for Helper I rankHelper I
4 years ago

Hi, thank you for your reply, appreciated, but probably I was not so clear.

What I need to know in Table1 is: 

1) Is the client in Table1[clienti]=Table2[clienti] if the answer is yes then

2) Is  Table1[giorni]=Table2[giorni in numeri]? If the answer is yes, then is OK.

My aim is to be sure that my client has the job done exactly at the right day of the week.

Thank you again

 

  • technolog's avatar
    technolog
    Icon for Super User rankSuper User
    4 years ago

    marabeda Do you mean something like this in results?

     

    • marabeda's avatar
      marabeda
      Icon for Helper I rankHelper I
      4 years ago

      Hi Technolog, yes is correct. Now I try your solution on my original table to check if it works and I let you know.

      I am gratefull for you prompt replay.

      Marabeda