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.