export portal records...

[Deep Thought II]

hi all~ is it possible to export portal records in FM 7? if so... how?

thanks.

[Fenton]

Go To Related Record [ Show, "Portal's relationship" ], use layout [ layout assigned to portal relationship's base table ]*

Export Records

Go To Layout ["Original"]

*Important to be on the correct layout, NOT the original record's layout (where the portal is).

[-Queue-]

You can also export from the parent record by selecting only child fields in the 'Specify Field Order for Export' dialog.

[SoCalMacDude]

I need to export data from parent record, then each of the line items in the portal, then next parent record, each of its line items in the portal, etc. to get a text file to send to a mainframe.

How can I interleave these records from 2 databases, and in the right order?

[-Queue-]

Then select both parent and child fields, parent first, then child. If there are multiple child records, then you will get multiple rows. Only the first row will contain the parent data; the following rows will be blank until the next parent's rows begin. There is no way to separate the parent data from its first related child record, however. You could create a blank child for each parent and then run the export. But this would most likely not be a desirable solution.