There are two ways to set up a calculation as part of a field's definition: A field of type calculation or a data field with an auto-entered calculation. Use the auto-entered calculation if you want to be able to change the value in the field directly by editing it. With either option you could use this calculation:
IF ( ID = "01" ; "Cash" ; "Check #" )
This assumes ID is of type text. If it is of type number, use:
If ( ID = 1 ; "Cash" ; "Check #" )
For situtations where there are more possible values than just two, a case function may be used or the field can be set to look up (copy) values from a related table of values.
Create your source field as an Auto enter text field. If you want the result to change if the id field changes then uncheck the box for do not replace field contents. In the calculation field use.
Case ( id="01" ; "Cash"; "Check #" )
Edit: I knew I was typing too slow and Phil would probably post before I finished. Lol
Phil and Ron,
Thank you! Thank you! This worked perfectly for what I needed. Since I wanted to be able to edit the field by entering the check number when appropriate I formated the field as a data field with auto entered calculation.
I was close to understanding the principle involved but I couldn't figure out how to format the IF statement.