set field commando with NumToText calc

[jeffer]

Hi There,

So here is the problem and this is a strange one!

In the database X I have a ordernumber in a numberfield. This field is combined with a text field in a calculation:

(NumToText(ordernumber) & " " & MyTextField)

So when the ordernumber is 10 the textfield returns "10 text"!

I have a relationship ® between database X and Y.

The relationship is like this:

textfield(database X) :: textfield(database Y) with the option for creation of related records on, not sorted.

And here is the tricky part...

I have a script that makes a record trough this relation. It has the scriptstep SetField and sets the textfield in database Y as the textfield in database X and since that relationship is not valid it will create a new record. When the field in database Y is set, an other relationship in database Y is valid and will lookup some data. The strange thing is that after the field in database Y is set, the ordernumber is not the same as in the X database. Instead of showing the data "10 text" it says "00 text". The same thing will happen when the ordernumber existst of 1 character. The field in database Y will show "0 text". The relationship that is made after the setfield step in database Y is not valid because the number is not right...but it still lookups the data?:??

All this happened suddenly...it always worked...did some of you guys and girls noticed this problem?

thnx allready and greetz...jeff