Exporting Related Information

[robinwoodstock]

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.

[comment]

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.