Hi all.
Happy holidays to all of you.
I have some fields based on another tables (lookup fields) and each record can have many of those sub fields. I have now those fields defined as lookup dropdown multiline as you can see in this image. No problem here, but what I need now is to have the ability to search for all the main records that contains (using the first field as example) EcologÃa In the programasID field.
As the values of the dropdown are stored like 1,3,5 (in the same example) I am not sure how to do the search or if is possible or how to program to have the required result.
Any idea is very welcome.
Thanks in advance.