Topic: Manipulating tables data
Hello everybody.
I'm coding noob, still learning. I was searching forums but can't make it work. I'm trying to make vehicle tracking database.
I have two tables: vehicles and fuel_fillings. In table fuel_fillings there is relationship field with table vehicles. One of the fields also is monthly_qty of fuel filled. What I want to to do is, for example, in from1 table grid1 I want to show summary for all vehicles where one of the column is cumulative avg fuel filings (vehicle1 - fuel qty month1 + month2..../number of months) - Cumulative AVG for all fuel qty per vehicle. Basically what I'm trying to do is to show footer(AVG) for field monthly_qty for each vehicle in summary tablegrid1.
Is it possible to do it with calculated field or some other way?
Also, it would be great if someone know if there is some link where I can learn about tables data manipulation.
Thanks all of you for helping me.
Stay well