companysql 

select r{Name of Company} from t{Company Master@@ERP Admin} where lower(c{Name of Company}) like lower('${Name of Company}%') order by c{Name of Company}

projectsql

select r{Project Name} from t{Project Master@@ERP Admin} where lower(c{Project Name}) like lower('${Project Name}%') and c{Name of Company}=${Name of Company} order by c{Project Name}

selfsql

NATIVE:select distinct(a.c{"+Field_name()+"}) from t{"+Form_name()+"@@"+Module_name()+"} as a where lower(a.c{"+Field_name()+"}) like lower('${"+Field_name()+"}%') order by a.c{"+Field_name()+"} LIMIT 40

sql:Code Field:Name Field:Form:Module

No example

hql:Code Field:Name Field:Form:Module

No example