multiple users in the same view

[crshuman]

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.

[MayMusic]

In this case you need to separate the table which is the best practice or create two reports on the same page one for submitter and one for requester which is not a good practice. :!: :!: :!: :!: :!:

[crshuman]

I was trying to avoid two tables of the same list of users, but I guess that's the best route though. Thanks.