Hi Cetin,

Sorry to bother you again.

The SQL SELECT ran after I recoded the commands to match your example. Thanks for that example. I see the difference. I never had to qualify table names before. This is all new to me.

I only have one final question. I was expecting to see translated descriptions from my translated codes appear in my CURSOR named rpt which later goes into my report. WHen I browse my CURSOR named rpt I don't see the descriptions which I thought were just JOINED from each of the 6 translate tables. Does that mean I am doing the wrong kind of join?

I want "OTHER" to appear in rpt.desc1 so my report show OTHER and not OT (the code for other). But I have no field called desc1 in my CURSOR rpt. Or do I have to CREATE CURSOR rpt first and put those new fields in ahead of time, before SQL SELECT?

Thanks for the final time today. I really appreciate your time and effort.