Exported data from Multiple Tables gets jumbled

[johnnyrocknyc]

Hello,

I've done my best to browse/search for this solution, so forgive me if it's been covered.

I'm trying to export data that exists in multiple tables to a spreadsheet/csv. When I do this, and there are multiple values, the export jumbles (seemingly randomly) the data that comes out if that data is in a different table.

For example. In my database, say I have a Project table, a Company table and a Contact table. The projects, companies and contacts are linked via a key, but the data I'm exporting exists in their separate tables. When I export Project, I will often get Contact A showing with Company B and vice versa. It seems that the export is ignoring the relationships between them.

So if I export from the Projects table a list of "Projects I'm working on", I might get results like:

Export line 1 - Project: iPhone : Microsoft :: Steve Jobs

Export line 2 - Project: Zune :: Apple :: Bill Gates

When I go to the Project Detail page, all of the data is correct. (iPhone:: Apple:: Jobs, etc.) The export is grabbing all the right data, it's just outputting it incorrectly.

(The Contact data for first name and last name (which are seperate fields, but the same table) is always matched correctly, which makes me believe that it's the seperate tables of the other data that is causing the mix up. )

I'd be greatful for any recommendations on how to get the data to export properly.

Thanks,

John

[bcooney]

If you are exporting from the Projects table, you must get the Contact info and Company info from the same relationship that is used to display it on the Project form.

Can you post a demo?

[johnnyrocknyc]

Thank you for your reply. The example in this post isn't pulling directly from my database. I will post an example as soon as I can.

Cheers,

John