AnsweredAssumed Answered

Best way to layout my database

Question asked by Jon1009 on May 18, 2010
Latest reply on May 27, 2010 by Jon1009


Best way to layout my database


Hi there pretty new to file maker and just wondering what the best way to set out this datebase would be


The first thing we do is login the sample which has a unique ID but the sample can be tested for about 7 different things could be (1 or could be all 7) what would be the best field setup for this would it be once field with checkboxes or 7 seprate fields for each different test.


The next thing I need to do is enter the test result for each test. Would it be wise to have a different table for each test? 


hope that makes sense.