WE dont know the value...the control value is in one table and the user enters the value in order field...If the qty exceeds the control value, all the trigger has to do is display the error message and ask the user to enter the value again.
The message gets displayed but the cursor does not go back to order qty field
this is the code
{mfdtitle.i}
define vari a as char.
ON ASSIGN OF pod_det.pod_qty_ord
do:
find first req_det where req_nbr = pod_det.pod_req_nbr No-lock no-error.
if avail req_det then
do:
IF pod_qty_ord > req_det.req_qty THEn
DO:
MESSAGE "Qty exceeds requisition qty".
< I need the cursor to remain in qty field after this message>
END.
END.
end.
REPEAT:
{gprun.i ""popomt.p""}
leave.
END.
Hope this is clear
cheers
chenthil
cecsno said:
If you know what the value is, why do you want the user to enter it?