suitable i.e. a) has only uniue values in column 1 b) is sorted on column 1 c) does not include response doc d) excludes replication conflicts you can use a @DBLookup - effectively using the same view as an index. Try some thing like below. The complexity is simply 1) a fast exit it CustomerName not set 2) code to deal with an error __________________ @if( CustomerName = "" ; @Return("" ) ; "" ) ; L := @dblookup( "" ; "" ; "(Manage customers)" ; CustomerName ; 2 ) ; @If( :isError( L ) ; "" ; L )
Return to top
. . assuming the view (manage Customers... (Alan J White 22.Jun.05) 
Print this page
