I would like to have a solution for this problem:
I have two tables: one main and one secondary
Main Table: usuario
id_nombre (Int)
nombre (Varchar)
Secondary table: nombre
id_nom (int)
nom (Varchar)
i use lookup filter in the main table
In the filter section I put this code:
"id_nom
<>'".n_nombre()."'"
Previously I put this code in global code:
function n_nombre(){
$nom = ew_ExecuteScalar("SELECT nom FROM usuario
");
return $nom;
}
The filter only works with the first result. When I create another new record I see all records in the child table. And I'm only interested in seeing the records that are not in the main table recorded.
thanks.