* For crsMLE >PartNum QtyPer TotalOnHand QtyRequired NetQty CurQty >100000 2 100 20 80 10 >100001 1 100 10 90 10 >100002 3 100 30 70 10 * For crsCNT >PartNum CurQty PartDesc >102031 10 Assembly 101 >100001 10 Assembly 102 >100002 10 Assembly 103 * For crsPM2 PartNum PartDesc .... 100000 Part A 100001 Part B 100002 Part CAfter SELECT WHAT cursor you want to get?