Steve:
Why wouldn't you just link the details to the header in order to retrieve the "order#". This would work well for both GridView and Crystal Reports.
It seems like such a trivial problem to solve with the existing data structure that I would suggest to Softrak that they just invest in creating the requested report and/or Inquiry screen in Order Entry and not spend money on changing the data structure.