Jump to content
  • 0

How to compress multiple values to only one in a view.


cbaker10
 Share

Question

I have 2 tables I have created a view to combine. One table is a list of teacher names and the other list is a list of enrollments. They are tied together by a teacher ID. I want to get just the teacher name from the teacher table and just the course from the enrollments table. The problem comes in because there maybe 20 enrollments for a certian course and there fore it will list the teacher and course 20 times. Is there a way to compress the multiples to just list it once?

I.E.

Bob Biology

Chris English

Liz Math

Any ideas would be greatly appreciated.

Thanks,

Chris

Link to comment
Share on other sites

1 answer 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.

Guest
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.

Loading...
 Share

×
×
  • Create New...