mariluzrm
Member
Hello.
Materials is a databasejoin (checks), Data - Table is t_mater . But I want that only appear the checks that correspond, that is, the materials specific to the element (they are in another table called t_matelm), I've tried (in Data - Where):
WHERE {thistable}.idtmat IN (SELECT idtmat FROM t_matelm where idtelm=elemento___IDTELM)
WHERE {thistable}.idtmat IN (SELECT idtmat FROM t_matelm where idtelm=elemento___IDTELM_1)
WHERE {thistable}.idtmat IN (SELECT idtmat FROM t_matelm where idtelm={elemento___IDTELM})
WHERE {thistable}.idtmat IN (SELECT idtmat FROM t_matelm where idtelm={thistable}.idtelm)
But none of them work... In other words, don't know how to access the value of the dropdown Element identifier.
Thanks.