Import Data from flat-database to relational-database

[Dieter Schmidt]

Before I start I need some tips and pleas excuse my bad english.

I have two databases, one is flat and one is a relational database.

example database 1

name
surname
street
city
country

example database 2

table NAME

prim_key
name
surname

table ADDRESS

adr_key
street
city
country

Both databases are filled with existing records. I want to import from
time to time records from the flat database to the relational database.
Whats the best way to do this with filemaker?
I also could use a relational database instead of the flat one, but i
think the problem resulting from that is, how to create the correct
adr_key and prim_keys, because in the database are existing keys that
shouldn't be destroyed?

Does anyone know how to do this?

[test@test.text]

It is possible Dieter,
import flat datbase into NAME database
(create extra fields for temp use)
Sort the records so that ducplicate values are close to eachother,
Export with summary option (eg city, street)
Import this info into the address file.
new addresses are created (primary keys are filled with data)
In your name database, lookup the corresponding primary key using a
relationship based on a unique value (street, ...)

good luck


Rob Paredis
FileMaker consultant
Belgium-Antwerp
[email]info@infortica.be[/email]
0032 4955741 12
"Dieter Schmidt" <flatline@stresstiming.de> wrote in message
news:bk49jn$f0v$03$1@news.t-online.com...

> Before I start I need some tips and pleas excuse my bad english.
>
> I have two databases, one is flat and one is a relational database.
>
> example database 1
>
> name
> surname
> street
> city
> country
>
> example database 2
>
> table NAME
>
> prim_key
> name
> surname
>
> table ADDRESS
>
> adr_key
> street
> city
> country
>
> Both databases are filled with existing records. I want to import from
> time to time records from the flat database to the relational database.
> Whats the best way to do this with filemaker?
> I also could use a relational database instead of the flat one, but i
> think the problem resulting from that is, how to create the correct
> adr_key and prim_keys, because in the database are existing keys that
> shouldn't be destroyed?
>
> Does anyone know how to do this?
>
>
>
>
>
>