Doug: yes, I think you SHOULD get your coffee now. And you bring up the other problem I had when I was trying to figure this out myself a few years ago. You could ship partial quantities of an item. So one item could have multiple invoice#s / tracking info.
That's what made my head spin and I never implemented a more accurate shipping record. Karen > Oops, you're right, my error. > The Order Detail table gets the invoice #, not the Order Header. > But even that would cause problems if there were multiple (partial) > shipments for an item resulting in multiple invoices. > Maybe the invoice number isn't even needed in the Order Detail; I did have > the order number in the invoice header table, so it could done with a view > - I'd have to look at that old db, it's been years. > > Can I go get my coffee now? :) > D
