Hi,

I have a form where the user put the employee ID, I need to display the name for the ID employee as a display field.

How can I do this?? If the employee ID change, the displayed name should change too.

Regards

JP

Roughly speaking:


field.<your_ID_field>:
when.field.changes:
(*** routine for filling <your_name_field ***)
display("<your_name_field">)

I would use before.display section.


field.emp.name:
before.display:
get.emp.name(emp.id)

I show in this file what I`m trying to do, the user gives the employee ID and the systems return the name.

How can I do this??

try this:


field.emno.nama:
before.display:
select tccom001.*
from tccom001
where tccom001._index1 = {:tihra907.emno}
selectdo
emno.nama = tccom001.nama
endselect

thank you friends!!

now it`s working..

now I have a question, how can you assign which field must be fill in first by the user in a form??

Do you mean the field order on a form? Or do you mean to force the user to input a certain field first before they can input any other field? for the latter you could make the first field in the form mandatory. Then in the before.display on the other fields you could say something like:


if isspace(formfield1) then
attr.input = false
else
attr.input = true
endif


Good Luck!

Mark