how to get parent data from child

[Joost Miltenburg]

Hi All,

I am doing an export of invoices with invoice lines. 1 to many off course.

However, the format that is required calls from data of the parent record to return in the child records.

How do I do this ? I can't figure out how to addrress the coloms in the parent. Or maybe there is a better way ?

TIA

[Fenton]

This can be done. But there are questions. What general format, text or xml? If xml, what are the element names? Same as FileMaker fields? If text, what structure? Several parents in one export file? Or just one? Can you post an example of the text.

[Joost Miltenburg]

I am doing a fm xmlresult result. I am trying to build a text file with ';' seperated values.

I have included an example file, which should explain a lot.

TIA

Joost

invoice_example.fp7.zip

[Joost Miltenburg]

to answer my own question...

I managed to get the data with