I tried to to take the data whinh431.wpon, whinh431.wseq, whinh431.item and displayed it at whinh999.wpon, whinh999.wseq, whin999.item respectively. But it doesn't take the data. I used message box to check whether the data able to retrieve or not. It give me correct result, but i'm wondering why it not shown in the whinh999.xxx field.

THE CODE:

field.whinh999.worn:
before.zoom:

select whinh431.*
from whinh431
where whinh431.shpm = :whinh430.shpm
AND whinh431.shpm = :whinh999.shpm

selectdo
display("whinh4131m000")
whinh431.worn = whinh999.worn
endselect

after.zoom:

select whinh431.*
from whinh431
where whinh431.worn = :whinh999.worn

selectdo
whinh999.wpon = whinh431.wpon
whinh999.wseq = whinh431.wseq
whinh999.item = whinh431.item

message("%s - A", whinh431.wpon)
message("%s - B", whinh431.wseq)
message("%s - C", whinh431.item)
endselect

All the message give me the correct result, but it does not appear in the whinh999.xxx field.

hi,
I think it doesn't display the fields, so try display() function for each field which you retrieve.

I tried to use display() function but it's not working. I change the field from Edit Form to display, it's working now. Thanks for your reply.