Importing multiple fields into an array

[jschwarz]

I'm converting an older version of a database into a newer one that we've developed for a non profit doing fundraising.

The old DB has "home phone", "address phone", and "other phone". The new DB has a 5-field array of phone numbers, and a corresponding popup menu with phone types, including fax, work fax, etc.

Is there any way to map the separate fields from the old DB to be imported into the array? Otherwise, I can only import the home phone, essentially.

Thanks

[dkemme]

I would import the database, deciding that the first array is home, second is work, and third is other. Then find all records with a home number, do a replace in the popup menu with "home", then find all with data in second and replace "work" in the second popup menu and so on..