FM 8.5Pro importing from one flat table in one DB to multiple tables in another, where to start?
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.
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
descriptions_pk - Auto-Incrementing, non-modifiable serial. Increments by one forever and ever
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.