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