I am in the process of creating a database for the Lab that I work for. We have between 800 and 1000 samples that we would like to track. Thus far I have a table set up that captures all of the information that I need on each sample (collection date, time, notes), but I am trying to figure out the best way to map the storage of samples and how many tables that would require. Any suggestions on the best way to do this would be welcomed.
Thus far, each sample is physically stored in a single cell of a 9x9 box. Each Box is in a rack and there are two racks. Each Rack is in one of three refridgerators.
- Rack H
- Box 6
- Cell 62
I would also like to display this information graphically in a way that I can click on a cell and bring up the related record. I have uploaded an image of what the boxes should look like.
Let me know if I can clarify at all. Thanks!