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

Discussion created by fmpuser0 on Jul 27, 2017
Latest reply on Jul 27, 2017 by philmodjunk

Hello to everyone,


I have uploaded my DB to 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.