AnsweredAssumed Answered

Convert Record Data to multiple field data in one record.

Question asked by brianmacinnes on Oct 5, 2010
Latest reply on Oct 6, 2010 by LaRetta_1

Title

Convert Record Data to multiple field data in one record.

Post

Hi All

I inherited a table where each specification for a Part Number was given an individual record. I want to create a table where there is one record for each Part Number and many fields in that record would contain the many specifications for the part.

Attached is the structure of the original table.

My first attempt was to create a new table with a relationship on part number. I need help coming up with a calculation to extract the specifications from multiple records to multiple fields. 

MT_DataList_Page_1.jpg

Outcomes