Script to turn repeating fields into new records

[Hefty517]

Last year, I created a database using my non-existant Filemaker skills, and committed a cardinal sin...instead of using a portal, I used repeating fields for ordering advertising space. Here is an example of what the record currently looks like:

Order ID

Client info

Media info

Run Date (repeater) Ad Size (repeater) Cost (repeater)

This would repeat several times, as a lot of space was reserved per media, per month. In other words, if I had ordered 4 ads for the month in The Times, each of those four ads would be repetitions 1-4 for Date, Size, and Cost. As I am now finding out, that causes tons of issues when trying to pull reports. I would like to create a new table, and write a script that would go existing record by record, pull out the repetitions, and make each line of ad info its own record. Once this is done, I would strip out the repeating fields and replace with a portal using the new table I just created. I'm not sure how I would start this, so any help would be appreciated by this barely functioning newbie.

[comment]

Import your records into another table. Select 'Import values in repeating fields by: Splitting them into separate records' in the second import dialog. Your existing table becomes the parent table, the new table holds the related children. Quite simple, really (but make a backup before you try it).

[Hefty517]

Thank you so much...I can't believe it's that simple. You have no idea how much better this makes me feel...and I learned my lesson - no repeating fields ever again!

[comment]

Never say never:

http://fmforums.com/forum/showtopic.php?tid/190245/