[SOLVED] Lookup

This topic is locked

[SOLVED] Â Lookup	9/23/2020 10:22:43 AM
PHPRunner General questions
P Philip author I'm using a lookup field on a EDIT page, the "link field" contain numbers as 1, 2, 3 and so on. I search a way to limit the lookup that user can choose only the same or higher number as is already saved. Any idea to put that in the "WHERE" in the lookup settings?


	Sergey Kornilov admin 9/23/2020
	You may want to use SQL variables. SQL variables will work in Lookup Wizard WHERE clause as well and you can refer to the currently selected value of the lookup wizard there. https://xlinesoft.com/phprunner/docs/sql_variables.htm Also check these two: https://www.youtube.com/watch?v=1pI-KwiAT4Y https://www.youtube.com/watch?v=Ao-vP-6Rr0g

Â Lookup