I have set up a system which allows our sales team to initiate a quote for a customer. One of the managers will then complete the quote, seeing that it has been initiated. If accepted, the quote will be converted into an open job where a bunch of documents are created. At the same time, a report will be updated to show that the new job has been created, so it can be entered into our financial system. What I would like to accomplish is to create a button which would appear for each record on the report (I have successfully created the button for each record...). I want the button to be tied to the record itself. Once the information has been entered into the financial system, I want our accountant to be able to hit the button and "delete" the record from the report so they can move on to the next job. I really just want the button to change the "job status" field to something other than "new job" so the record will no longer appear on the report.
Is this possible? If so, how do I get the button to change the correct field? I'm sure the code or macro wouldn't be all that complicated, but how hard is it to have the button, which is automatically generated for each record, tied to its corresponding record and only effect that particular record?
Any ideas are appreciated! Thanks!