Field calculation is too slow for my script to use it

[Eloi]

Greetings everyone,

I have a 1 to n relationship.

On the "1" side, I have set up a field to sum up a specific field in all the related records on the "n" side.

I have set up a script that is executed on a given field modification. It uses the calculated field mentionned above to perform some more calculations.

My problem is that the script seems to be executed before the calculation field has been updated so that I am always one step late.

Is there a way to go round this ?

Thanks in advance for your help.

Eloi

[bcooney]

Do you Commit records in the trigger script?

[Eloi]

Greetings bcooney,

No I didn't. I now do and have re-organized my script with this new step. It now works as I needed.

I really need to improve my FM skills...

Thank you again for your help.

Eloi

[Eloi]

Hello again all (and bcooney),

I have come across a new issue related to the same topic.

As I replied to bcooney, the "commit records" step solved my problem regarding my calculated field and script calculation mess. But, I then figured out that the issue would remain on the opening of the layout and the first data capture.

Meaning that when I type in a number in the field (my script is executed on every modification of this field), my calculated field will be one step behind my script calculation. Then, when I type in a second number, the calculated field catches up the script.

Any help would be welcomed. I have been doodling around this issue adding, removing, re-organizing my scripts' steps but can't find a way out.

What is this due to ? How can one get the rid of it ?

Thanks i advance for your reply and help.

Best regards,

Eloi

[bcooney]

Please post a demo file showing us the script.

[Eloi]

Greetings bcooney,

Sorry for not having replied to your post before. I have been through major professional complications.

Unfortunately I cannot provide the demo file as I have worked on it quite much since and have given up using the calculated field. I am now using scripts to fill this field in.

I thank you much for your help and really apologize for my rudeness. I hope you won't blame me too much and will still be so prompt to help.

Best regards,

Eloi