Need Schema Advice for Setting Up a Report

[Rich]

Greets, all:

I'm trying to reformat an existing report but what's holding me up is how to set up the schema (see attached)--as is, there are 12 fields assigned per Test Code (5002, 5003, 5004, and 5005) so there are 48 separate fields, each using E-SQL calculations, to generate the numbers for the report. (Mind you, all the data is in one table.) I figure FileMaker Pro can natively do it much easier--and with many fewer fields!--using summarizing functions but I'm scratching my brain trying to set up the schema. I'm thinking that each Test Code should have its own table--so I can keep the design columnar as-is--but what should the connections be? Copy the existing table four times (one for each test code) and use a Self-Join [X] relationship with Test Code as the key field, or...?

TIA for your help!

Report.pdf

Edited August 21, 2018 by Rich