Hello all

I am building a system for someone and have run into a quirk. As an example, if I have a table called Parent and a child called Child, and both have a number field, Number. The Child record gets its Number from a Trigger on update: on Parent

Number := Parent.Number

I now have two buttons on the child record that link a parent to the child and update the number to something different to the parent. If the Number of Parent is 2

Parent := 1;
Number := 6

Gives Number a value of 6, as expected

do as server
    Parent := 1;
    Number := 6
end

Gives Number a value of 2, the value of the parent. It runs too fast for the additional update of Number := 6.

Any ideas on how I can run the server version but with the correct result?

Many thanks John