hi
i want set approval on the base of query so i write query as follow
SELECT T0.[CardName], T0.[CreditLine] FROM OCRD T0 INNER JOIN OCRG T1 ON T0.GroupCode = T1.GroupCode INNER JOIN OINV T2 ON T0.CardCode = T2.CardCode
WHERE T1.[GroupName] ='INSTATION' AND
T0.[CreditLine] >= 0 AND
T0.[CreditLine] <=50000
GROUP BY T0.[CardName],T0.[CreditLine]
but on this condition approval is not set so if i write query wrong then pls send updated quer
regards,
sandip