I want to hide a button when a certain value is found in a related table (firm_project).
My calculation looks like this : firm_project::_fk_type_firm_id = 2
A PROJECT can have multiple "fk_type_firm" related to it. I don't know what function to use to search through "firm_project" table. I manage to make it work since I used the value of the first "_fk_type_firm_id" available (3) in the "FIRM_PROJECT table but I don't understand why it seems to only look at the first value of that table and not go through it.