I have already created following tables
1. Sample Info (Fields: SampleID, Sample Name, TestCode)
2. Sample Results (Fields: ResultsID, SampleID, ???)
I dont know what fields I need to create here. Each SampleID can have multiple TestCode so accordingly that many number of record needs to be created in Sample Results table so Results can go there for respective tests. I am using SQL server 2005 back end and Access 2010 Front End.