AnsweredAssumed Answered

Multi-Table Export to Text File

Question asked by RichardHart on Mar 21, 2015
Latest reply on Mar 22, 2015 by philmodjunk

Title

Multi-Table Export to Text File

Post

I am unable to find a way to export the contents of all fields in all tables into a single text tile.
You have a primary Table named CITY. Related to it are the Tables named HOTELS and RESTAURANTS. What you want is to export a text file something like this:

Boston 
Hotel 1
Hotel 2
Hotel 3
Restaurant 1
Restaurant 2

Chicago
Hotel 1
Hotel 2
Restaurant 1
Restaurant 2
Restaurant 3

However, any kind of export gives you only the first hotel and the first restaurant. A Report does the same. Printing a list of portals to PDF doesn’t work. Any ideas short of a long string of scripts and export tables?

Outcomes