"If" function problem #2
CONTACT table has a field called "Supporter?" with a Yes/No radio button field control.
I want to automate "Supporter?" by a calculation looking to the "DonationAmount" field of the DONATION table.
I've tried every combination of this without success: If ( DONATION::DonationAmount= ""; "No" ; "Yes" )
I have turned OFF the Don't evaluate if fields are empty and the Don't replace field switches.
The "No" part works but when I enter a dollar amount in the 'DonationAmount' field and committ nothing happens.