[Feedback] Wish for query

[Feedback] Wish for query

I am a serious user and my application TradeMaster is now in use in my small trading business. So far it has proven to be indispensible.
One big wish I have is querries.
In my case, I have Form SKUs which records all product info, Form Purchase orders which records all PO's, Form PO-items which records items under each PO, and Form shipment which lists shipments each PO-item makes.

"shipment" is related to "PO-items" via "ID" of "PO-items";
"PO-items" is related to "Purchase orders" via "MTA PO#"
"MTA PO#" is related to "SKUs" via "MTA#"

Now in the end, I need a "master shipment tracking" View, which, based on Form "shipment", displays all information that a project manager needs - product info including product descriptions, vendor information (including vendor address, bank info, etc.)

However, in a View, the only info that can be displayed is the fields in the Form itself, and the IMMEDIATE related form. Thus I can display info in PO-items Form but not the more "upstream" Forms (SKU, Purchase order, and vendors)

If somehow you can allow the creation of a Querry which acts like an intermediate "Form", that will be great!

Currently my only work-around is -
Create fields in "PO-items" that I will use later in the final report, including "vendor address, vendor bank info, product description," etc.
Then create a "on Load on Edit" action to set these values based on related "upstream" forms - vendor, SKU's, Purchase orders,


This is not an ideal solution but can partly solve my problem.

do you have any plan to include Querry in future releases?

Thanks.