create many records from one source record.

I have a record, lets call it record A. Within record A there about 50 fields and in each field there will be a number ranging from 0 to 50.


For each one of these fields I need to create a separate record with header information from record A and the number from that field.


For example.


Record A

Name: Bob Smith

Field 1: 1

Field 2: 0

Field 3: 4


and so on up to Field 50.


This will become


Record 1:

Bob Smith

Value: 1


Record 2:

Bob Smith

Value: 0


Record 3:

Bob Smith

Value 4:


All the way to record 50.

(1) Answer