Export related records

[cmcfarling]

As an example I have a Customes table. The main fields in that table are Name & Address. In a related table are individual contacts. The main fileds there are FirstName,LastName,Email. Each customer has multiple contacts.

I want to export the data from the Customers table as a tab delimted file to be opened in Excel. Each line (record) in the .tab file should include all of the fields noted above. So, the .tab file should look like this:

Name,Address,FirstName,LastName,Email

Name,Address,FirstName,LastName,Email

Name,Address,FirstName,LastName,Email

Name,Address,FirstName,LastName,Email

However, when I do the export, FMP exports a record from the customers table and separate records for each of the customer contacts. So the .tab actually looks like this:

Name,Address

, ,FirstName,LastName,Email

, ,FirstName,LastName,Email

, ,FirstName,LastName,Email

, ,FirstName,LastName,Email

Name,Address

, ,FirstName,LastName,Email

, ,FirstName,LastName,Email

, ,FirstName,LastName,Email

, ,FirstName,LastName,Email

Name,Address

, ,FirstName,LastName,Email

, ,FirstName,LastName,Email

, ,FirstName,LastName,Email

, ,FirstName,LastName,Email

Is there a way to make FMP join all of that data on export so it is formatted like the fist example?

[sbg2]

Export from the related table. Your export field list should look similar to below:

Customers::Name

Customers::Address

Contact::FirstName

Contact::LastName

Contact::Email

[cmcfarling]

Ok, got it. I have to add the releated fields from the Customes table (Name, Address) to the layout for the related table that I will export from.

Easy enough just not obvious at first I guess.

Thnx