Creating New Records from Existing Fields
I have an fp7 database which has 8 fields whose respective names are dates. I would like to create, for each record in my database, 8 new records with the dates from the Field names plus the values that are in the 8 fields into a new text field. So currently I have:
|Field 1||Field 2||Field 3||Field 4||Field 5||Field 6||Field 7||Field 8|
|Value in Field:||Red||Green||Blue||White||Red||Green||Blue||White|
For each record in the database I would like to put the field names into a new field called "Date" together with that field's current value into a new text field called "Note".
The result would be that I would have 8 new records for each current record.
For example, Field 1 above would become a new record with "1/2005" in the Date field and "Red" in the Note field and so on.
|Value in Date Field:||1/2005|
|Value in Note Field:||Red|
I am sure there is a simple Loop script to do this but I am not familiar enough with Loops to write it correctly and would greatly appreciate any suggestions.