Lookup Wizard

This topic is locked

Lookup Wizard	8/16/2017 3:41:22 PM
PHPRunner General questions
G georgweber author can i access in the where expression on the lookup wizard a field value from the same add page which i fill out before i click to the lookup wizard field? something like this: "prefix <> (SELECT aeronave FROM reserva_voo where data = 'values(date)' and reserva = 'values(time)')" the values(date) is a data field in the addpage the values(reserva) is a data field in the addpage after i fill out this to field i click on the lookup wizard field thank you for any help


	Sergey Kornilov admin 8/19/2017
	Yes, this is possible in PHPRunner 9.8. You need to use a new SQL variables functionality to refer to other fields on the Add page. Here is the WHERE clause you can use, just make sure field names are correct. `WHERE data= ':date' and reserva=':time'`