Forum Discussion

jppuam's avatar
jppuam
Icon for Helper V rankHelper V
4 years ago
Solved

bring field from 3rd table

Hello, i need to create a calculatedtable with data that is from 3 tables, like the picture below. i have 2 tables connected through the dates table, and other (tax) connected to payments table.  ...
Need Help
  • moizsherwani's avatar
    moizsherwani
    4 years ago

    I have used a similar structure to the one you have given. Can you see if the calculate table sample I provided in my earlier message helps? 

     

     

jppuam's avatar
jppuam
Icon for Helper V rankHelper V
4 years ago

thank you guys, Meanwhile, i've upload the imagem with the relatioships.

daxeralmighty, you're right, but my sources are in excel files, and thats how they arrive to me..

 

I've the OBJ_ID that are in the invoices table.

than i've to match in payments table, those who are in the invoices.

and i want to bring, for each row (that exists in invoices and payments table) the 2 Tax (A and B) with the corresponding values.

 

thanks for the help,

JP