I am developing an application with lookup fields and I would like to make reports with filters from anther form.

https://creator.zoho.com/kevin.loussouarn/consoadapt/#

I allow access to support.

In form Production -> Usine de Reims, the user select the id channel thanks to a lookup field related to Standardization form.

Each id channel have a zone area and a consumption type:

Z0 total

A1 - South Wing - Air conditioning

A2 - South Wing - Lighting

B1 - Amphi A - Lighting

....

Now, in report, I would like to display all value for area "South Wing" or all values for "Lighting"

Bottom line, I would like to filter the "Area Zone" or the "Consumption type" and not only the "id channel"..

How is it possible ?

Thanks.

Regards,

Kevin