I am wondering if someone could advise me on the best way to organize my form(s) so that I can easily organize the data associated with a certain individual.
I have 100 fish that are implanted with a PIT tag that acts as a unique identifier for that fish. The fish are sampled monthly and over the course of at least a year (sometimes 2 years) we collect various morphological data and images.
My current form enters each monthly sampling in as a record with each fish as an entry within a repeat of the record. The fish are sampled randomly, which means I have to be able to sort them out by PIT tag later. The problem I'm coming up against is finding a way to group the current dataset based on the PIT tag in a way that I can extract the data AND images efficiently. I can use summary reports to export the measured data, but not the images. And I can't figure out a way to use individual reports to group by PIT tag and report the various parameters and images for each individual.
Did I set this up incorrectly? I know I'm not using the software as intended, but could I still be doing something better for my end goal? Should I be using different software? I was expecting the reports to be like Access reports and they just aren't (unless I'm missing something?).
My form is attached along with the format for the summary report that is almost perfect except for not being able to add images due to it being a repeat, but gives the idea of what I'm going for. And I've also attached my attempt to get the individual report to work, but haven't figured it out.
Please help!
