AnsweredAssumed Answered

Calculations between tables

Question asked by MelissaSpinelli on Mar 27, 2011
Latest reply on Mar 28, 2011 by philmodjunk


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??