I am using Filemaker Pro 12.
I have 3 fields:
Field 1 either contains data or is empty
Field 2 always contains data
Field 3 is where I need a formula...
Question: If Field 1 contains data (i.e. it is NOT empty), I want the data in Field 2 to automatically be duplicated in Field 3.
Any wisdom please?