Developer’s Guide (Mac OS)

3-14 FileMaker Pro SDK Developer’s Guide
1 To upgrade repeating field data to a relational table, you will need to
separate repeating fields by importing the data into another database file.
For example, to break out the repeating fields from the Invoices database
below, create a Sold Items database, and then import the repeating fields
into it, choosing to split repeating field values during import. When you
establish a relationship from the new Invoices database to the Sold Items
database, Invoice Number will become the key field.
Importing to the new solution file
This section assumes your end-users need to import data from their 2.x
solution files into the enhanced 3.0 solution files. If your solution files
already contain the necessary content (for example, a database of real
estate listings), you’re ready to distribute your new solution files after
you’ve converted the 2.x solution files.
Here are sample steps to convert the Address database above, and to
create scripts to import data from the end-user’s 2.x Address file:
1. Convert copies of the 2.x solution files, making sure to keep the
filenames the same as the end-user’s.
2. You’ll need to make sure that this solution uses new filenames, for
example, Address2. Because the filenames have changed, be sure to
update all of the relationships, scripts, and value lists during the
conversion process.