Greetings all I have a problem with a lookup. I need to perform this query with a QueryBuildDataSource object so that I can use it in the lookup.
TableA tableA; TableB tableB; select * from tableA exists join tableB where tableA.fieldOne == tableB.fieldOne && ((tableB.fieldTwo == 'BELL' && tableB.fieldThree == '0') || tableA.UomClass == 'Calendar'); The problem is that I don't know how to use the '||' (OR) operator using a Query or QueryBuildDataSource object. Does anyone know how to do this. If there isn't a way, the other thing I wouldn't mind doing is to just pass the select statement above to a QueryBuildDataSource as a parameter. Something like this QueryBuildDataSource qbds = 'SELECT * FROM ...' Does anyone know how to use a normal sql statement in a lookup? Any help would be much appreciated! Thank You B
