AnsweredAssumed Answered

Hide object when a value is found in another table

Question asked by gcardin on Nov 4, 2015
Latest reply on Nov 4, 2015 by gcardin

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.

Outcomes