Calculations between tables
I recently divided my huge database into multiple tables to make it more stable. Now the simplest calculations aren't working and it seems to be when I try to use fields in different tables.
I have a schedule and am simply doing a calculation such as:
task1 = task2 - (table::duration * 7)
at this instance task1 and task2 are in one table and duration is in a related table
the tables are related by a single common id code
what do I need to do to make this work??