exporting contacts with multiple related data
Apologies if this has been covered, I find similar queries but can't seem to find a thread with a solution.
I have a People table, with child tables for variable contact data like phone/email, and related to a Company table for current work info. How can I create an export that will pick up *all* related data? into basic csv/xls table format
Ex: Joe Smith, Address fields from table A;
home phone, mobile phone, etc, (and lables) from child table B;
personal email, work email, skype, etc from child table C;
company name, title, main number, url, address, from related table D.
I recognize this is 3d to flat, and less obvious than it appears at first glance. Grateful for any observations.
My final goal is import to Mac OSX Address Book, in case any one out there has resolved the full excersise.