Hi guys,
I am trying to build a database but got stuck. Dunno much about it.
I want to my database to have samples, and those samples are put through a test which are run every day or twice a day.
First I want to be able to put a result on the test and depending on the test it should trigger another test or a repeat test and flag the sample so when i run a query that sample comes up again. I want to be able to trace down all tests and results obtained on every single sample.
I am not sure how to go about this, if i do it all in one table with multiple columns for the tests , like test1, test2, repeatTest1, repeatTest2... And the same for the runs.
A run is done twice a day or more depending on how many samples I obtain.
My tables would be like this
Sample Table
SampleID SampleNr Test
Test Table
TestID Test SampleNr
Run Table
RunID RunNumber Date Test
I am confused about the relationships in order to make it work.
Can somebody help Please I thought it was going to be easy but couldnt make it work.
Cheers