Inspection Checklist Structure
I'm relatively new to Filemaker Pro, and I'm trying to figure out the best structure for a series safety audits. There are 5 different form, all with basically the same structure. There is a header with basic info, date, location, employee, etc. That I can do, but the problem I'm having is with the body. Each safety audit has between 50 to 80 different items that must be checked. Each item itself has short description that just text, a yes, no, N/A dropdown list, and a edit box for comments. The 5 audits are for different types of location, so have different number of items to check, different description of items, but the same genral structure.
What I'm trying to figure out it the best way to structure this. The simplest, and most time consume and poorly disigned, way of completely this that I have figured out is a whole lot of fields labled check 1, check 2, so on, and comment 1, comment 2, so on. However, this is oviously not a perfect solution. Any idea on how I should tackle this?