4 Replies Latest reply on Jul 27, 2017 6:31 PM by philmodjunk

    Combining Data in 2 Tables, Using Total from a Third Table and Hiding Detail in Summary Report

    fmpuser0

      Hello to everyone,

       

      I have uploaded my DB to https://goo.gl/Ko5b5F. This is what I'd like to accomplish:

       

      a) Is there any way to import the data from table "Non Operational Expenses" into "Total Expenses" in an automated way, i.e. I am aware that I can export the data and then re-import into the table I want but what I am looking for is some kind of a trigger that would update Total Expenses every time that a Non operational Expense is added

       

      b) Field "Total Hours Flown" on layout "Summary" is not working properly. How can it be fixed?

       

      c) On layout "Detail" I need to hide each record detail under Fixed Expenses.

       

      Thank you for any assistance you can provide.