Vessel tracking, reporting and inventory setup! No idea!
Sorry to have absolutely no idea at all... but I'm trying to set up a database, with daily, weekly and monthly input of different information, regarding a ship's position, its environment, a report of it's catch, sorted by species, and weekly/monthly reports of inventory levels (fuel, bait, etc..)
I can set this up fine as a single record for each ship... but I need to be able to keep the information of each individual daily/weekly/etc. update... and then combine totals of this in reports...
My main issue obviously is how to make a single record on one table that is effectively a total of every record on a separate table...