i got some trouble with a SQL query for pick lists. I am going to create a report, that displays from the pick & pack manager the hole BP and order informations. Therefor i wrote this query, which works properly :
SELECT T3.* FROM PKL1 T0 INNER JOIN RDR1 T1 ON T0.OrderEntry=T1.DocEntry AND T0.OrderLine=T1.LineNum INNER JOIN OCRD T3 ON T3.CardCode=T1.BaseCard WHERE T0.AbsEntry = [%AbsEntry]
My problem is, the bp and order query creates a new line for each row of the pick list. So the bp repeats as often as the order is long. I tried to use a DISTINCT statement, but it does not work.
Any ideas how to solve it ?
Thanks in advance