How to display search results in a list of lists

[K5]

We would like to create an application to compare ocean freight quotes, but are having trouble figuring out how to display the data.
Any advice would be appreciated.

1) Situation

For ocean freight rates, multiple shipping companies provide quotes for each route for each shipping company and transportation method (container, consolidation, AIR, etc.).
We have created tables for each of these and connected them with refs.

<Table Layout>

Route table
↑ ref
Operator table
↑ ref
ShippingCompany table
↑ ref
Shipping Mode table (enter freight rates here)

Containers are charged on a per-unit basis, while consolidation services are charged on a revenue-ton (R/T) basis.

Up to here, no problem.

Table images↓
Table image

2) Display (search) method

I would like to be able to display a list of quotations for all companies when the user enters a route and R/T, but I don't know how to do this.

-------------------

Example: A user wants to send a 10 CBM package from Hawaii to California.
Suppose the following freight rates have already been entered in the database.

Using shipping company a with Operator A: $1,000 per container, $100/RT for a consolidated shipment.

Using shipping company b with Operator A: $2,000 per container, $200/RT for a consolidated shipment

Using shipping company a with Operator B: $3,000 per container, $300/RT for consolidated service, and $1,000 for AIR

Using AIR company c with Operator B: $ 2,000/RT by AIR

Using AIR company c with Operator C, $500/RT by AIR

-----------------

As an image of completion, I would like the following list to be displayed when a staff member enters the following information in the search page, for example

Place of shipment: Hawaii
Destination: California
R/T: 3

Input & Result image↓

Sorry for the poor explanation, but I hope you understand!

[Marc_Dillon · Accepted solution]

I would first add an [operator] (virtual?) column to your Shipping Mode table, for display purposes.

Then you can generate a list of results with an expression such as:

FILTER( 
  Shipping Mode ,
  AND(
    [operator].[route].[loading] = [_THISROW].[loading port] ,
    [operator].[route].[destination] = [_THISROW].[destination port] ,
    ?? = [_THISROW].[R/T]
  )
)

Note that I don't understand what the R/T input data is supposed to match in your tables, thus the questions marks.

https://help.appsheet.com/en/articles/2357308-filter

[K5]

@Marc_Dillon 
Thank you for your kind reply.
I think perhaps I am doing the basic modeling wrong, but it did not behave as I expected.
I will reconsider with your advice in mind. Thank you very much.