Kevin,

Thanks for the reply. However, when I tried this as follows

SELECT Projectid, ;
a.oecname AS ownname,;
b.oecname AS engname,;
c.oecname AS conname ;
FROM curTemp1;
JOIN tmpoec a ON curTemp1.Owner = a.oecid;
JOIN tmpoec b ON curTemp1.Engineer = b.oecid;
JOIN tmpoec c ON curTemp1.Contractor = b.oecid;
INTO CURSOR curTEMP

I get a table with each projectid being repeated for every oecid in the tmpOec table resulting in a huge resulting table. Have I left something out?

Thanks again,
Russell