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.