>>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 >>>>