PRESENT: I have a group of clients that become eligible for award periodically. Each of these clients also has an advisor. At the end of each period, I send emails to each advisor whose clients may be eligible for the award. This email includes various details about the The advisors look over the client's details and then email me back who is and who is not eligible for the award.
DESIRED: I would like an online form (PHP/HTML based) to take the place of this. What I envision is me having a Microsoft Excel spreadsheet of my clients and their data along with their advisor and their ID number and uploading that to a Microsoft Access table in a database that is currently on a server. Advisors could then go to a webpage. On this webpage, they would enter their ID number. Then they would receive a list of any client who is eligible for the award. There would then be two radio buttons on the right-hand side, one for Yes and one for No. There would also need to be a submit button on the bottom of the page. Once they have decided who is eligible and who is not they could submit their decision. This would trigger an email to be sent to a specified address with instructions for a Yes decision and for a No.
If you need examples or details of what I am requesting please ask. Any other questions or concerns, don't be afraid to ask.
Thank you.