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? 

     

     

moizsherwani's avatar
moizsherwani
Icon for Continued Contributor rankContinued Contributor
4 years ago

Can you please tell me why the same "Date" table needs to be connected to the Invoice and Payments table?

 

Also is the relationship between Payments and Tax 1:1 or 1:*?