Week 6: New form and reference table

I ended up recreating the bat data form so that it is parsed in the order needed for upload, and to clean things up a bit. The database now has a reference table that will be used to compare against submissions. When a user selects a location, all other relevant data to that location will be auto populated in the new entry. This keeps the number of items on the submission forms minimal, reducing the risk for errors. I am becoming much more comfortable with MySQL. Using a query, I can scan the reference table to see if a location matches the user's selection, then pull all data from the matching row.