Dropdown listbox

This topic is locked

Dropdown listbox	12/4/2006 2:56:42 AM
PHPRunner General questions
J jje author Hi, Is this possible to change the the query of the dropdown list box. I would like to use joins in the query for e.g. select a.userno, a.userdesc from table_user a where a.userno not in (select b.user_no from table_department b where a.userno = b.user_no); I am still using version 3.0 as this is a modification on a existing program. Regards


	Alexey admin 12/4/2006
	Hi, sure, you can. Add WHERE expression in Lookup wizard dialog. Here is the expression you need to enter: "userno not in (select b.user_no from table_department b where table_user.userno = b.user_no)" If you don't want to rebuild the pages modify $LookupSQL variable in GetLookupData function in include\..._functions.php file.