updating index - can it be done or do I need to do this another way?
FileMaker Pro 11 Windows
database is as so:
Quotes---------< Building--------Labour-----------Labour total
Each quote can have multiple buildings. Each building has a labour database. A script analyzes the building and extracts labour costs from the selections the user has chosen in their building and stores the values in the labour database. I have added the Labour Total database with calculation fields that grabs the sum of each category in the Labour database.
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. Can I not do this task this way?