Before I dive head first into starting something, I wanted to reach out for different perspectives on the approaches to building an inspection form database. It will be the usual fare of some questions with 'yes/no' but also some values will be recorded. In addition, there will be multiple inspection forms in the DB - perhaps one for one piece of equipment and another form with different questions for another piece of equipment. I'd like to get started on the right track.
Anyone got time for thoughts on tables to set up, naming, relationships and workflow? Or if you have a sample file, that'd be great. I'm currently working along the lines of a Report table, a Questions table and a join table for responses but I'd love to hear other ideas.