I have a simple database that has one related database. Using FMPro 6 I am able to export all records and all related records to a tab-delimited file. The script in the parent db to do the export simply finds all records, sorts them, then does the export script step. The field order of the export basically looks like this:

field1

field2

.

.

.

subdb::field1

subdb::field2

This script in FMPro6 exports all the fields specified from parent record 1, then loop and export all the fields specified in all of the related records in subdb database one right after the other, then go to parent record 2 and export it's fields and all it's related records fields, etc.

Upgrading to FMPro 7, it now only exports the fields from the parent record specified and then the data from only the first related record for each parent record. It no longer loops by itself to export all of the related records.

Does this sound correct? Is there a simple way to do the export the same as version 6?

Thanks

As I'm facing the same problem, I'm upping this thread...

If the source table has never been sorted before export, all is OK, I'm getting the same output than in V6.

If I'm exporting the data when the source table is sorted, then I'm getting only the fields of the first records !

Once it's done, it's impossible to go back we'll never have the others records !

Quite curious, isn't it ?