I know I can export the records to mer with field names. But when I export the records from related file, the field names will appear with the relationship name in the front. E.g. Relationship::Field_Name

Is there a way I can get the field names without the relationship name?

Kfok,

I have no direct experience of exporting mer so forgive me if this is stupid but could you not create a copy of the related file, break the relationship and export from that ?

Phil

If all the fields which are being exported, are from the related file, then us to GTRR script from the original file and export the records directly from the related file which contains records.

If there are couple of fields from the related file then create a calc field in the master file to view the related field data and export them. Keep the setting not store the values and calculated when needed.

If there are couple of fields from master file then do the reverse of previous case.

I want to export all the fields from the related file but only the found records of the main file. But all the records of the related file are exported. In my export script, I have:

Go to Related Record[show,"Relationship"]

Export Records[]

Please help.

The export records script step should be from the related file. It exports the records from the file from where you run the script.

I run the export script from the related file but all the records are exported but not related records of the main file.

Export from the main file and include related fields in the export order. Or, create a multi-key of the ids from the main found set by populating a global with return-separated (¶) values. Create a relationship from the global to the related file's parent key field, Go to Related Records [show only related], and export from the child file, including parent file data.

Thank you guys for your all your input. I finally did it.