>Well, yes.
>I can do that with the orders and order details.
>And I can do that with the invoices and invoice details.
>
>Where I'm stuck is getting info from all four tables at the same time....as I need invoice details AND order details in the same data-set result - along with some stuff from both header-tables too.
You can combine additional table in the same SQL statement. But I would suggest adding one table at a time, this should be clearer, easier to debug, and in some cases much faster to execute.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)