First the task:
I want to add a record to a table.
1- I enter a number in a global field (I need the global because I re-use it a different part of the layout.
2 - I search (find) to see if a record exists, if so I display it.
3 - If not found then I prompt asking if a new number should be entered or if a record should be created with this number.
4 - I then select 'Add' from the custom dialog to add the record and move to the field where I want to enter the Name of the item.
1,2,3 work as expected.
However when I move to the Name field a CR is placed in front of the point where I want to enter the Name.
I have tried trimming the field but that doesn't work.
I don't understand why the CR is there in the first place.
Obviously I am doing something wrong, somewhere, but I have spent hours trying to make this work, without success.
Therefore I need help
I have attached images of the scripts in case that will be helpful
Confusing, to me. If you make a field global, don't all the records have that value? And if you change it, don't all the records now have that value?
I would use an auto-enter calc with a custom Trim function on the global field (might need a commit), not the Set Field, to see if that helps.