AnsweredAssumed Answered

Calculation Field help

Question asked by CarlDunkelberger on Aug 9, 2011
Latest reply on Aug 9, 2011 by CarlDunkelberger

Title

Calculation Field help

Post

So I have two tables link together in essentially a one to many relationship. I am trying to populate a calculation field based which should, when based on a "where clause", would return one record. My Sql would be 'Select answer from (innerjoin code) where QuestionID = "1"' I have tried if(Answer::QID = 1; Answer::Response; "Unknown") but nothing shows up. Can anybody give me a hand here?

Outcomes