AnsweredAssumed Answered

Lookup Help

Question asked by jdhelle on Oct 9, 2009
Latest reply on Oct 9, 2009 by comment_1


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.