Thank you for your post.
What operating system are you using with FileMaker Pro Advanced 15.0.2? What version of operating system? If Mac, post the crash report up to and including the crashed thread. This will provide some additional information.
Are you able to set the field to any static value?
If you create a new script (do not duplicate) that simply sets the field, does this work?
Is Layout Setup based on the "main" table? If not, try switching to a layout based on the "main" table and set the field, and return to the original layout.
Answers to these questions will help me determine how to proceed next.
Hi and thanks for responding promptly
I've done quite a bit more testing before getting back to you (as we're no doubt in different time zones) and I think the issue is actually down to the time taken to load records in the layout - specifically in the filtered portal. I have now removed unstored calcs (based on ExecSQL) from the portal and it's performing OK.
If you want I can send the Hang log but I think I can mark this as resolved.
Client is FM15 Pro Advanced 22.214.171.124 running on OSX El Capitan 10.11.6
Connecting to server over VPN
Also tested on windows PC (remote connection so on same network as server) which is where I was alerted to the issue actually being the time taken to load a record - over 30 seconds.
Thanks again for help and suggestions