AnsweredAssumed Answered

Lookup Help

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

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. 

Outcomes