Lookup wizard

This topic is locked

Lookup wizard		8/16/2018 09:03:05
PHPRunner General questions
G georgweber author I don´t know if there is a solution. But maybe somebody have an idea I mad a reservation table with the fields Data, Time, Airplane, Instructor. Now i will add a new reservation with Data and time. on the Airplane field i use the lookup wizard and chooce the table with the airplanes. but now i would like that the drop down field airplane just show those aiplanes which not have a reservation already on the same data and time.For this i need to make a where statment with a database select command in the lookup wizard for the airplane field. I use the PHPrunner Any help please? Thank you in advance

Mark as Solved Mark as not solved

4 replies


	Sergey Kornilov admin 8/16/2018
	This can be done with the help of some custom coding. One option is to use Field Events: https://xlinesoft.com/phprunner/docs/field_events.htm Another option is to use Custom Dependent Dropdown boxes: http://asprunner.com/forums/topic/22701-custom-dependent-dropdown-boxes/


	Please delete this account 8/16/2018
	Another option is to use Custom Dependent Dropdown boxes: http://asprunner.com/forums/topic/22701-custom-dependent-dropdown-boxes/ [/quote] https://www.youtube.com/watch?v=CUfrRkEceU8


G	georgweber author 8/17/2018
	Another option is to use Custom Dependent Dropdown boxes: http://asprunner.com/forums/topic/22701-custom-dependent-dropdown-boxes/ https://www.youtube.com/watch?v=CUfrRkEceU8 [/quote] Can you help me to do this please? How would be the code?


	Please delete this account 8/17/2018
	https://www.youtube.com/watch?v=CUfrRkEceU8 Can you help me to do this please? How would be the code? [/quote] http://asprunner.com/forums/topic/13854-concat-fields/ ... for inspiration ..., you would need to make use of CONCAT feature to form a list similar to what the Excel formula seen in the video did.

4 replies

Mark as Solved Reply