AnsweredAssumed Answered

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

Question asked by donjuancarlos_1 on Sep 20, 2012
Latest reply on Sep 21, 2012 by 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?
          

              

Outcomes