>>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.
>
Never had a reason to before. ;)
>
>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.
Sometimes doing multiple SELECTS is faster (and simpler) than trying to do it all in one statement. If you run into any other problems, I'll try to help out.
If you really need those tags, refer to that E-mail I sent you back in April about adding tags to WorkShop.