The problem I am having is that the calculation fields don't automatically update when I make a change to the Labour database, I get incorrect results in my Labour Total database.
What kind of fields are you using? Number fields with an auto-entered calculation or fields of type calculation? Auto-entered calculations in Labour Total won't automatically update when data is changed in Labour, but calculation fields in Labour Total will update automatically.
I am using Calculation fields. I think the problem lies in the fact that I delete all line items in the Labour database every time I run the script to update the numbers. I do the delete because I don't know how many lines are required each time.
That's why I was wondering about updating the indexes for the new records. They don't show up automatically.
Deleting all the records like this would seem unecessary, but whether you do or not, calculation fields should update automatically. If they do not, there is likely an issue with the relationships linking records in Labour Total to Records in Labour.
If you want advice on that, please post the actual details of your relationships. One way to do that is to upload a screen shot of Manage | Database | Relationships.
Nope I got it. A combination of a slight script rewrite, and the addition of Commit Records/Requests and a screen redraw, and it's working.