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

Login