Erik,

Thanks for the input. I like your second method. The problem I have is that the Order Header table has 82 fields (most of which are Logical). A grid would probably be to cumbersome for data entry. A multi-page form would probably work best for the Order Header table with a grid for the order line-item table.

I guess what I'm still not sure about is coordinating the new/save/revert logic for all three entities. Based on the above information, would you still go with your "preferred method" and how (conceptually) would coordinate the new/save/revert logic amongst the three entities?

TIA for you advice.

Don Burton