Relation with related table

Discussion created by LeszekŁuczkanin on Dec 9, 2017
Latest reply on Dec 12, 2017 by philmodjunk

I have two related tables BUDGET and OPERATIONS, relation many to many. I use it to plan my budget and to verify it. In my table OPERATIONS I don’t have a field which describes currency, because this information for every operation is in related table ACCOUNTS.

I need to set a relation between BUDGET and OPERATIONS and describe currency. How can I do that? Is it enough to set a calculation field  OPERATIONS::cCurrency = ACCOUNTS::Currency and then relation BUDGET:Currency = OPERATIONS::cCurrency ? Maybe I can set up relation with related table?


Zrzut ekranu 2017-12-09 o 20.54.26.png