[FM6] Exporting address info for mailing

  • Follow


Hi, 

Intro:
I have two files: the main file contains company (address) info and a second
file that contains one or more contactpersons for each company.
Both files are related by company ID.

Question:
How do i create a script that exports all company address info for each
contactperson in that company. Each line in the export file must contain the
full company address and the name of one contact for that company, the next
line contains the full company address and the name of the next contact for
that company and so on.
Remember: the export file must also contain the address info for these
company's that have no contactpersons (in the secondary file)

Thanks in advance for the answer,
Hans

0
Reply Hans 12/21/2005 4:08:50 PM

You have to cheat to create this export.
Create a Utility table somewhere.
It should have 2 fields "ID Company", and "ID Contact".
Import the contact records into the Utility table populating both ID
fields.
Find only the company records that don't have any contact records and
import them into the Utility table also but only populating the "ID
Company".
Sort the Utility records by related company name then related contact
name.
Export the related company name, address, contact name etc.

0
Reply FP 12/22/2005 1:34:49 AM


1 Replies
211 Views

(page loaded in 0.031 seconds)

Similiar Articles:













7/26/2012 11:48:04 AM


Reply: