>Stephen,
>
>TIW has no tags on the OPNO field in either the SOTRAN or in the RODETAIL tables. Maybe you could try adding tags on that field to those tables and see if that helps.

Fred, I found this out yesterday trying to get the plain old relationships working. when that failed, I wondered why this index never was instituted? Oh well.


I'm to this point now:

SELECT lv_master2_shipping.partno, lv_master2_shipping.styledesc, ;
lv_master2_shipping.sono as sononum, lv_master2_shipping.lineno,;
lv_master2_shipping.wono, lv_master2_shipping.ponum , ;
Sotran.sono, Sotran.opno as opno, sotran.t_date ;
FROM ves!lv_master2_shipping left outer join f:\tiwvan\sotran ;
on lv_master2_shipping.wono = sotran.sono ;
WHERE lv_master2_shipping.ponum= vp_ponum ;
group by 3,4 ;
into cursor query



I am still getting the syntax correct to make the above a sub query and a join to rodetail for the proper loadcenter description.

I've got a few hours in this beast now and it's getting close. The above runs inside a few seconds 3 tops.

Thanks for the feed back.