Skip to Content
Former Member
Aug 14, 2008 at 09:21 AM

Formatted search on User Table



I need to set formatted search for user table which is @DCNR . My Requirement is that i need to Pick CST NO from BP Master . In my user screen i had taken CARDCODE value using CFL which is binded to the field U_ven in the table @DCNR.Using this CARDCODE value i need to pick CSTNO from BP master to the user screen which is binded to the table (@DCNR).My Query is as follows but it is not working,

SELECT crd7.taxid1 from crd7 inner join @dcnr on crd7.cardcode = @dcnr.u_ven where crd7.cardcode = $[@dcnr.u_ven]

U_VEN field contains card code value.

Do i need to follow some other terms in order to write formatted search on user table.

Hope some one would help to fix this problem.

thank u,

-Ashok Krishnan