Importing then splitting data

[VirtualBob]

I need to import data from a spreadsheet then spilt that data into different relational files. I have a person file that could take all the data initially but then I want to push that data into separate related files such as address, events, etc as that is how the legacy database is structured. Do I create a script or action that copies multiple fields at once and pushes them in to related files? If so how do I do that as I've only created scripts that copied individual fields before, not many at once. If someone has a previous example I could modify that would be great.

[rivet]

- convert your spreadsheet to FMP (sourceDB), and create a secondary key field

- import just the fields you need for the person table from your new sourceDB.

- export the primary key from the new person records

- import (update) just the secondary key in the sourceDB

- now the sourceDB is ready to split into the other tables

 

good luck