Jump to content
  • 0

multiple users in the same view



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.

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...