export relational to flatfile

[Laurathompson5]

I have a contacts database with 4 tables:

Contacts: contact no, name, address etc.

Phones: contact no, phonetype (work,home, fax etc), phone

email: contact no, emailtype (work1, work2, home etc), email

date: contact no, datetype (followup, followup2 etc), date

I would like to export data to:

1. Filemake mobile (which does not support relational). They suggest we can do lookups. How would you suggest I look things up?

2. Outlook contacts (access data at work. I have only one license for FM mobile and want others to be able to look contacts in outlook). This is a flatfile.

thanks

Laura

[Ugo DI LUCA]

Never done that but all four files uses the Contact N

[jasonwood]

I'm not really sure what dilucaugo68 is suggesting, but it gives me an idea.

Create a new database that will have the fields necessary for your flat file, then simply import from each of the 4 databases, one at a time, matching by contactNumber. Note that if you do it this way, you will only be able to have one phone, one email, etc for each contact.

If that's not enough, I think you'll have to just import the main contacts database, and then use a script to grab the data from the phone, email, etc. databases. Note that you will be limited to the number of phone and email fields you define (unless you separate them by carriage returns in a single field).

[jasonwood]

this was a duplicate post... sorry

[Ugo DI LUCA]

That's it Jason. Export from 4 files to one using Contact N