Routes

Legacy Contributor

Hi, Can anyone guide me in the right direction to show the Route description in an SOP order. The Route code itself was easy Sname.sn_route and looking through slook I can see the two respective fields but they just prints 'auto generated code'
Basic stuff but its driving me crazy
Thanks
Ken

alan-bourke

iif(used("slook"),iif(seek("R"+sname.sn_route,"slook","slook1"),slook.lk_desc,""),"")