I have a database used for tracking product testing. I have a study table which has all the information for a specific study which is then linked to a table that has the details for the different timepoints (study interval table) the samples must be tested. Many product have annual testing...
