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?