I have what seemed to be a simple database with three tables i.e. Customers, Fabric and Tests.
Each customer has more than one fabric, and each fabric has more than one test carried out on it.
I have set it up with customers having fabric as a sub table (the customer FK in the fabric table), and...