Hi everyone
I am starting a new project for a database and am very interested to hear everyone's opinion on best design technique
Basically the database will need to store data from a number of different checklists maybe 30 or 50 relatively (in some cases almost completely) different checklists (that may have 30-50 points on each checklist). The checklists will be about different equipment and the data recorded will occasionally be similar however the similarity between all checklists is that for each piece of info recorded the user will need to be able to enter a comment and select from either yes, no or N/A.
Sometimes the data will be similar and can therefore come from a combo box or default value however overall the user will need to be able to comment over top and they will always need to be able to choose yes, no or N/A
If I create a table for each equipment type/ checklist and therefore a form or number of forms for each checklist do I have to also have 3 radio buttons for each field as well? This seems like an awful lot of data to be saved and will mean that the wheel must be re-created many times as well
A major benefit of this system I think is that it will be much easier to alter and will work great for specific validation
Your thoughts are appreciated