relation with null value

[IT2Be]

I built a relationship on two values:

organizationid = organizationid
globals.value = invoicesid

globals.value is in this case empty... (Is it really "" or is it null)

Now I don't know if this is possible but what I try to archieve is find all orders in this case where the organizationid = organizationid and the invoicesid is still null (or empty).

How can I do this? What I defined above doesn't work...

1. organizationid = organizationid works...
2. invoicesid = nullable...

[jcompagner]

the problem is that in youre case the global is ""
to set the global really to null you have to set it through javascript:

global.xxx = null;

then the related foundset should return the values where xxx is null ...

[IT2Be]

Thanks Johan, it works now!!!