3 Replies Latest reply on Aug 9, 2011 11:01 AM by CarlDunkelberger

    Calculation Field help

    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?