I currently have a project where fifty people are going door-to-door daily to collect information from a targeted list of homeowners.

I have a master target list (~11,000 homes) and a survey form for the people to fill out at each home. So when a person goes to the home, they select a lookup field to select the respective target for that location (example: they visit 123 Main Street - and select it from the drop-down then complete the survey).

My end goal is to have the master target list show me the most current status. For instance, if they visited the home and someone took the survey, the status would be "Complete". If they visited the home, and nobody was there, the status would be "Active" since we will go back to that home and try again to get a survey.

Here is where it gets tricky...

I can't simply do an update to the target list, because I need a full log of the employee activity as I need to see/analyze their performance daily. For example, I need to see how many homes John Smith visits each day on average, what his conversion rates are, and how he stacks up to the other employees - among other things.

Equally important though is having a master list of all 11,000 targets and what their latest status (complete/active) is.

So I need both.

There are some ways I thought this may be able to work:

-If there is some way in a report to filter to the last date (max?) that a survey was submitted for each target.

-If there was even just a way to update a column on the target list with Complete or Active, that would even work great. For instance, if someone submits a survey and the status is Complete - it sends that status to another status column on the target list and overwrites the last status.

I'm certain there are another dozen or so ways to workaround this...however, I'm not nearly advanced enough as you all are to know them just yet.

I'd really appreciate any hand-holding and genius you all are willing to lend. Thanks again in advance!