Are there any practical options, that anyone could suggest, that I can explore that will help me solve my conundrum? i.e A way of displaying the actual records from the related tables that show the values matching my search criteria from a "find layout".
If not, and the only (or best) way is to have a single table of all test results what would be my best options to create this table. Create a new FM table that would populate itself from the existing tables in FM, or create from my starting material (Excel worksheets)?
Any advice appreciated, I've attached my basic test FM file that may illustrate my problem better.