Hello, I have got a script running every hour.
The idea is:
Table A with field 1
Table B with field 2 and field 3
We needed to perform a find in table B with records with some criteria of table A field 1, but the user experience was not good (too much time running).
We made a calculation field (Table B field 2) and then a script that performs find based on table B field 2 and fills table B field 3 with table A field 1.
Then, when user performs find based on table B field 3 gets good performing time.
The script runs ok (a lot of time running) on a FileMaker Pro connection, but running scheduled on server stops very often.
Can you help me?
Any alternative ideas to accomplish the objetive?