I have a single users table and also a request table. A user (submitter) can submit a request on behalf of another user (requestor). When a request is made, the user_id of the person logged in submitting the request is recorded in the request table under the field submitter_id. There is also a drop down field of users in the submit request form that will record the requestor in the request table under the field requestor_id.
I am trying to create a request detail view that will contain the details of the submitter and requestor, but because the submitter and requestor info are coming from the same users table it will not display the details of both the submitter and requestor at the same time. Is there a way to accomplish what I'm trying to do besides having a separate table for submitter and requestor? Thanks.