2. PHPRunner General questions
  3. [SOLVED]  Default value from other table for Lookup wizard
This topic is locked
[SOLVED]

 Default value from other table for Lookup wizard

 		7/19/2012 9:35:05 AM
PHPRunner General questions
E
 expo101 author

I have the following challenge in my PHPRunner project:
The default value in a dropdown box should come from a value in another table. The value is also one of the dropdown box options. For a schematic view see:here.
What PHP code do I have to insert in the Default value box on the 'Edit as' screen? This is the SQL query:

SELECT audience_1

FROM t_trip

WHERE t_trip.org_id = t_departure.org_id

AND t_trip.trip_id = t_departure.trip_id


Looking forward to your suggestions.