This topic is locked

Use Lookup to populate session variable

8/29/2007 8:58:09 AM
PHPRunner General questions
W
wrjost author

Hello, everybody,

on a form I am using the lookup wizard to have the user select a name. Now I need to get the index number (primary key of that table) which corresponds to that name. If possible, I would like to display that number in a read-only text field on the same form.
Any ideas?
Thank you in advance,

Wilfried

Alexey admin 8/29/2007

Wilfried,
add an alias for your Lookup wizard field.

I.e. modify SQL query this way:

select

name,

name as nameid,

...


Then set Edit format - Readonly for nameid field.