Hi,

 

I want to filter a lookup list in this way:

 

1) I have three forms,  Categories, Subcategories and Products

2) Everyone of these forms have a multiple look up field to the other two forms

3) When entering a new product, the user selects as many categories as he/she wants, no problem here, no filtering, all Categories show up

4) When selecting Subcategories, I want this list to be filtered in a way that only those Subcategories belonging to the Categories already selected by the user show up.

 

 

For example:

 

the user selects these categories: Motorcycles and Bycicles

The Category Motorcycles has Subcategories Red and Blue

The Category Bycicles has Subcategories Big and Small

Another Category (Cameras) has Subcategories Digital and Legacy

 

I only want Red, Blue Big and Small to applear, I want to filter out Digital and Legacy

 

So, in the subcategories field, I need to have a criteria statement that selects only those Subcategories whose Categories contain any of the Categories selected by the user in the form being filled.

 

Application link: https://creator.zoho.com/yaxche/catalogo/

It has Edit Access for Support enabled.

 

Is this possible?

 

thanks a lot