This is my setup:
I have a parent table (Cruises) containing a ref, which is the connecting field to connect it to a children table (Prices).
In this children table, I have the prices for all the individual cabins for each cruise. Each have an availability field (number field), and a type field (Inside, Outside, Balcony, Suite).
What I need to do is find the cheapest cabin with an availability above 0 for each of those 4 types for each cruise. And put those results in 4 individual fiels.