AnsweredAssumed Answered

relationship requiring unstored calculation

Question asked by GeraldRivard on May 24, 2011
Latest reply on May 24, 2011 by GeraldRivard

Title

relationship requiring unstored calculation

Post

I'm having a problem with a two-criteria relationship that involves an unstored (and necessary but apparently unstorable) calculation.

Consider this subset of my data structure:
 Table Steps:
   ID
   AgentID
   Status (a calculation that relies on Sum(Sessions::Minutes) )
   ToDoFlag (a calculation that will be 1 for certain Status values)
 Table Sessions:
   ID
   StepID
   Minutes (a calculation from start & end times)
 Table Agents:
   ID
   ToDoMatch (a calculation that is always 1)

I'm trying to build a relationship where
  Agents::ID = Steps::AgentID
AND
  Agents::ToDoMatch = Steps::ToDoFlag

It doesn't show any records.  If I remove the second criteria it does show records, including ones I don't want.  I think the problem is that the calculation fields that Steps::Status relies on include Sum(Sessions::Minutes), which is unstored.  But I can't change it not to be unstored, I think because it uses Sum. 

Any ideas?  Thanks in advance.

Outcomes