Relationship problem

Classic Servoy
1

Is this kind of relationship possible?

globals.guser_com_id == peo_com_id
AND
peo_sec_id == 0

Or must such be put into a calculation and then a relationship built from there?

In FMP I would often build a case statement in a calc such that if the above conditions were met, then return a “1”. All tables had a constant of “1”. This made possible a relationship to filter out the records I was really interested in.

Somehow I sense that in Servoy there’s a more efficient way of doing this. Am I right?

2

i think you mean the other way around i believe?

so:

globals.guser_com_id == peo_com_id
AND
0 == peo_sec_id

this is not directly possible, because you can’t type values directly inside the relation dialog but just do this:

globals.guser_com_id == peo_com_id
AND
globals.zero == peo_sec_id

and just set the globals.zero to 0