Summarising portal data
I need some help, again. This is what I have at the moment. I have tables for Vessels, Oil Samples and Oil Sample Data (see attached pic). I have a layout based on Oil Samples and a portal in that layout linked to Oi Sample Data. In this portal, each row is an oil sample record for a piece of equipment, e.g. Main Engine Port , Gearbox etc. There are multiple oil sample batch records for each vessel as sampling is done on a regular basis.
What I would like, is another portal that displays all the records for a single piece of equipment, e.g. Main Engine Port. I have no idea how I need to set up the tables and relationships though to make this work. Can someone please point me in the right direction?