I need to design a layout that will display the contents of boxes in a Freezer. The Freezer has 18 racks (named AA-AR), each rack holds 13 boxes, and each box is 10 x 10 (with a total of a hundred spaces in a box).
this database is focused on lab samples that are placed in vials and then placed in boxes into the freezer.
Any suggestions on 1) how i should create the tables? & 2)how i should create the layout
I am using FileMaker Pro 8.
Things the users would like to see:
-Sort by Racks to get a list of boxes that a rack holds
-Drill down to specific box and see contents (all 100 samples)