Okey Steve, it's all yours. :)

>Hey Sergey, leave some work for me! :)
>
>>Steve,
>>
>>You can change the second select to eliminate 1's w/o 3's

SELECT *, 000000000 AS rn ;
>>	FROM test ;
>>	WHERE Status = "1" ;
>>          AND ItemNum IN ( ;
>>             SELECT DIST ItemNum FROM s3) ;
>>	ORDER BY ItemNum, Cust, Sku ;
>>	INTO CURSOR s1 READWRITE
>>

>>>