Fixing the owner and requester fields

Another problem that we previously noticed with the issue creation form is that the Owner and Requester fields were also free-form input text fields. However, we know these are integer values in the issue table that hold foreign key identifiers to the tbl_user table. So, we also need to add drop-down fields for these fields. We won't take the exact same approach we took for the Type and Status attributes, as issue owners and requesters need to be taken from the tbl_user table. To complicate things a bit further, because not every user in the system will be associated with the project under which the issue resides, these cannot be dropdowns populated with data taken from the entire tbl_user table. We need to restrict the list to just those users associated with this project.

This brings up another thing we need to address. As mentioned in the Iteration planning section, we need to manage our issues within the context of a specific project. That is, a...