4 Replies Latest reply on Sep 21, 2012 10:15 AM by donjuancarlos_1

    updating index - can it be done or do I need to do this another way?

    donjuancarlos_1

      Title

      updating index - can it be done or do I need to do this another way?

      Post

           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?