In a project I have two tables (table_a // table_b) in which a drop-down field is configured as LOOKUP to a third table (table_c) filtering the records by a field common to all three (FAMILY, int 11).
Following the examples, I use this filter string:
(strval($this->FAMILY->CurrentValue) != "") ? "`FAMILY` = " . $this->FAMILY->CurrentValue : ""
The result is that in table_a, the dropdown is filtered and in table_b, it is not filtered and all the records of table_c are displayed. The fields have the same configuration (INT 11)
Any idea what could be happening?