I need to export a set of records including all the related information into an XML file. For example, the primary record is a book and I have another table containing all the authors related to a particular book and another table containing all the related marketing descriptions - and so on.

Is there any way to export an XML file and have it include all the related records - i.e for all four authors related to the book?

Any help or pointing in the right direction very much appreciated.

Is there any way to export an XML file and have it include all the related records - i.e for all four authors related to the book?

You can simply export from the Books table and include field/s from the Authors table in the field export order. Or vice versa. You'll probably want to use a XSLT stylesheet to get the output file into the format required by your export destination.