1 Reply Latest reply on Oct 9, 2009 5:40 PM by comment_1

    Lookup Help

    jdhelle

      Title

      Lookup Help

      Post

      Here is the field's calculated value formula - If ( Number = BA::BA_Number and Medium = BA::Type and not IsEmpty (BA::'DD_Number) ; Lookup ( DD_Owned::Coupling_Number)) - works perfectly.  I stuck the ' before the DD in DD_Number to keep it from displaying a smiley face...)

       

      However, when the lookup finds a match I want the calculated field to be "Yes" and if no match is found "No", not the value from DD_Owned::Coupling_Number.

       

      Maybe I'm using the wrong function to accomplish this??

       

      Help would be most appreciated. 

       

      Using FileMaker Pro version 10 on a Mac. 

       

      New to FileMaker.