After learning how to get a Custom Dropdown with Concat I wish PHPRunner then automatically offered the equivalent lookup for VIEW and LIST pages.
Thanks to Sergey's help here in the forum I got a primary id number representing a specific doctor record in another table to give me the first name and last name concated together for a dropdown selector in an Edit page.
And when I use the dropdown wizard as a lookup selector for other values I will see the text values in a record instead of its numeric value, which is exactly what I want.
But the Custom expression -- here is what worked for me: concat(first_name, ' ',second_name) -- in the Lookup Wizard that gave me a dropdown list only gives me dropdown that works for editing pages---it does not affect the read-only views of the List and View pages.
When I view records on the first list page I still see the doctor_id as a numeric value even though the lookup wizard gives me the text equivalents in the other fields from different look up tables. Every field in a row that I used the Lookup Wizard for to give me a text value from another table looks fine. Only the field where I used the concat expression in the Lookup Wizard stays the same...a numeric value rather than the firstname and lastname that matches the Dropdown table for Editing.
I would like the read-only equivalent for doctor_id 2006 to read on the View and List pages as "Lynette Wilson", for example.
How can I get the equivalent code that makes the Dropdown list of Doctors first and last names to also produce the same effect on non-edit views?
I hope I have expressed this clearly enough?
Thank you for helping me to see my way through this.