Greenhorn Alert
To this point our team has utilized excel for data capture. We are ready to make the leap into a tool that is more robust and also allows for the creation of a simplified user interface. Knowing that, here is my goal...
To create a database that will enable users to enter information into a form that looks similar (but much cleaner) to this...
that is then recorded into a table that would look similar to this...
Key Note
- Currently on the Form, the filter names are just labels. I have yet to figure out how to get the field (filter name) from a separate table (filter info) to auto populate (either based on department selected or predetermined with a form created for each department). This database once created will have approximately 60 filters in 7 departments. My reports will be set up to look at historical trends of these filters on an individual base and to verify each department is entering data for every day for each filter. I will also set up max and minimum values on the magnehelic readings to trigger alarms if a filter is operating outside typical parameters.
So to start....
- How can I get the single date and operator fields to be applied to each filter name, mag name, and observations?
Simple right? Thanks for whatever help or at the very least entertainment you are willing to provide!