Hi Steve,
We've done the same as Doug has suggested with Gridview. The Order number is on the OE History file or the OE Current Header file depending on the frequency of clearing out of the current order file.

Drive off of OE header history, and show items shipped and invoiced, and link to any open sales order that has back orders on it.

And as a bonus link to the PO line items to see the expected delivery date for any back orders that are non on hand in IC.

Your client request is fairly common, but we like the drill down efficiency of this view with Gridview, so we wouldn't do with an OE query in OE alone (by Softrak).

Best.
Brian
_________________________
Brian Stief,CPA,CA
Stief Group www.stiefgroup.com
Link2 Systems www.link2systems.com
800.540.3164