Can you post the DDL for Site, OrderHeader and OrderDetail as we might then understand the problem a little better.
What is the process for entering data into the OrderHeader and OrderDetail tables, is it a Manually typed in through a UI and then used to update the Site?
_________________________________________________________________________
SSC Guide to Posting and Best Practices