I have three look up fields all dependent on one another. At the moment these look up fields do not have multi line in the drop down box. However I want to now give more options.
I noticed that this is possible but the options do not display properly i.e.
if i have a table with
State Name School
Alaska John Johnhanson
Alaska John Junior
Alaska Harry Portway
Alaska Edward Higher
Florida Karen Junior
Florida John Johnanson
Florida John Junior
If the state Alaska was high highlighted I would expect that :
Name would show
John
Harry
Edward
And school to show
Johnhanson
Portway
Higher
Great.. it does
However if I highlight Alaska and Florida it shows all records i want it to show
Name
John
School
Johnanson
Junior
This is just an example, I guess i need to write my on script for this. Can php runner do this?
Regards
Richard