>I have not seen TIW for sometime - but as I recall the SO number is in the TIW header file. So once you have the SO # (I'd get that from straight SBT searches) I think all you would need would be TIW tables. Of course I was just thinking of getting the status of each line item on the SO. It appears that you are doing more that just getting where or what process a line item is in WIP. Am I right? BTW the select statement was very nice.
>
>John
It's kind of like that.{grin} TIW is more straight forward {normalized} than SBT. When it's done I'll post the improved sql.
__Stephen