This topic is locked

Lookup wizard

8/16/2018 9:03:05 AM
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

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/

HJB 8/16/2018
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?

HJB 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.