The field should be type text with an auto-enter calculation as opposed to field type calculation. Uncheck "Prohibit modification . . . . ." in the field definition dialog.
I think If( Same as mailing = "Yes" ; Mailing Address; " ") should work under these conditions.
As an auto-enter calculation, I think I'd use: If( Same as mailing = "Yes" ; Mailing Address; self )
That will leave the contents of the field unchanged but available for editing into something different if the Field is cleared or "No" is selected. (And then I can clear the "do not replace existing field contents..." option.)
If ( Same as mailing = "Yes" ; Mailing Address ; Self )
Thank you all - I tried "Self" & the double " " - they both work. Pretty simple actually, however now I feel really stupid.
Is there somewhere that I can get a list of what I believe are called parameters. For example the word "Self" and the double " " so that I can learn what they represent?
Again, thanks for the help.
Self can be looked up in Filemaker help. As can If functions.
"" is simply the empty string and is used throughout filemaker expressions as a way to return a null result.
" " would return a single space which would look the same, but not always function the same.