AnsweredAssumed Answered

FM 8.5Pro importing from one flat table in one DB to multiple tables in another, where to start?

Question asked by cpudenusa on Feb 4, 2010
Latest reply on Feb 4, 2010 by KenS

Title

FM 8.5Pro importing from one flat table in one DB to multiple tables in another, where to start?

Post

Hi,

 

Using FM 8.5 Pro on XP and my experience with FM in general is pretty limited.

 

This is a highly simplified version of the schema. 

 

table1:

Video_Titles - text

Video_Titles_pk - Auto-Incrementing, non-modifiable serial.  Increments by one forever and ever

descriptions_fk -  related to descriptions_pk in table2

 

table 2:

descriptions_pk  - Auto-Incrementing, non-modifiable serial.  Increments by one forever and ever

eng_desc

fra_desc

 

I am importing from another DB that has all of this information in one flat table.  

 

I just want to know how I would begin even attacking this with a script or if possible via the GUI and if my schema could use modification to ease this process that would be helpful to know.

 

Thank you. 

 

Outcomes