You're welcome.

>That worked great - thank you.
>
>>You have to use UNION to comboine 3 reps into one cursor
>>
>>

>>SELECT invpost.salesrep1 as salesrep,
>>		PADR(ALLTRIM(salesrep.fname) + ' ' + ALLTRIM(salesrep.lname),50) as repname
>>	FROM invpost
>>		JOIN salesrep on invpost.salesrep1 = salesrep.salesrep
>>	 WHERE NOT EMPTY(invpost.salesrep1)
>>UNION
>>SELECT invpost.salesrep2 as salesrep,
>>		PADR(ALLTRIM(salesrep.fname) + ' ' + ALLTRIM(salesrep.lname),50) as repname
>>	FROM invpost
>>		JOIN salesrep on invpost.salesrep2 = salesrep.salesrep
>>	 WHERE NOT EMPTY(invpost.salesrep2)
>>UNION
>>SELECT invpost.salesrep3 as salesrep,
>>		PADR(ALLTRIM(salesrep.fname) + ' ' + ALLTRIM(salesrep.lname),50) as repname
>>	FROM invpost
>>		JOIN salesrep on invpost.salesrep3 = salesrep.salesrep
>>	 WHERE NOT EMPTY(invpost.salesrep3)
>>ORDER BY 1
>>INTO CURSOR curRep
>>

>>