Hi all, I'm new to Filemaker and hoping you can help me understand and work around what seems to be a strange behavior...
I have a field (MyDatabase::TextField) in a database which I have defined as a "Text" field.
I place the number 3 in it . So far so good. I can see "3" in there.
Now I want to update MyDatabase::TextField so that it contains "3,1".
The "1" comes from a different Text field (MyDatabase::DifferentField).
I use a script with the following syntax:
Set Field [MyDatabase::TextField; MyDatabase::TextField + "," + MyDatabase::DifferentField]
Instead of seeing the expected "3,1", the field MyDatabase::TextField instead shows "4".
What am I doing wrong?
Thank you in advance for your guidance.