In the example you’llneed to create the relations every time, but if you use the retrieve type == reference then you could setup the data to have the policies associated to a policyexport object that is then associated to the file document specialization. The you’ll need to create the relation between the 100k policy records and the policyexpport object once and then associate the policyexport object to a new filedocument generalization object for every export, then just creating 1 relation. You’ll need to setup the template differently then by using the reference retrieve type.
Sean
Erwin’s answer is the way I would approach this. However, if you are exporting 100,000 records, perhaps the CSV module is a better option for you: https://appstore.home.mendix.com/link/app/108605/Mendix/CSV It seems much better suited for the number of records you are working with.
Mike
Thanks for the answers, I realized that the Docs are very misleading and that I can and should use an existing association – no need to create one as the Docs indicate. I am now using an existing association and that entity for my InputObject and it’s working pretty well.