I am trying to create a field that if empty pulls from a different field in a different table.
Field: Personal Company
Other Field: Company::company
How do I set it up so that if Personal Company is empty, it fills it with Company::company, BUT if it is NOT empty, it does nothing (as in, leaves the entered material in the field)?
I am guessing it is something along the lines of: If(IsEmpty(Personal Company); Company::company; ???)