At this point, you’ve finished your interfaces and scripts, but your solution only contains a few test records, and you probably have a significant amount of pre-existing data that you would like to migrate into your solution. You could always enter it manually, but usually it’s more efficient to import it using FileMaker Pro’s Import Records command.
In the Learn phase, when you imported two worksheets into the Landscaping file, everything went smoothly because we had prepared them for the import process. Similarly, for your existing data to import smoothly into your solution, some preparation is required. This goal will guide you through the preparation and import process.
Here’s what you’ll do:
- Prepare your spreadsheets for import
- Prepare your spreadsheets for relationships
- Import your spreadsheets
- Set the foreign key in your secondary table
- Test the results