New to filemaker and I have an issue that I cannot resolve.
Trying to use set field to set the value of one field to the value of another field. Both of the fields are number fields.
My syntax is correct, but nothing happens when I run the script (I put the target field first, followed by a semicolon and then source field).
I noticed that when I enter the calculation (which, in this case, is the name of the source field) the calculation window says "calculation result must be text". This could be the problem, but as i stated earlier both fields in my set field are numeric fields.
Why is filemaker requiring a text result and how do i resolve this?