I am designing a portal for my employees to submit orders to a database. After submitting you can view the orders in a table. I have a dynamic page that links each order to the table and displays it full page with any images or notes that may have been added by them.
I would like my management team to be able to view these orders on the dynamic page and select a checkbox or drop down to "Complete" the order. I want the complete to show up as a "boolean" check mark or the word "complete" on the table. I'm stuck right now because no matter what submitted order I choose from the table its only changing the boolean or text field of the most recent submission. In an ideal world I would love to have the completed Date & Time as well, but right now I am more concerned on getting the complete function to work