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

    Lookup Help



      Lookup Help


      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.