Hiding duplicate values in a portal

[HPage]

Hi,

I am designing a database for a training company. I keep track of client (big companies), learners (the employers of the big companies), and courses.

In the courses layout I have a portal that shows which learners did the specific course. In the clients layout I have a portal that shows what learners are employed by them. Now I want to create a portal in the client layout to show what courses has been done for a company. I created the portal and it works (getting the value through the learners), but it repeats every course, for every employee of theirs that did the course. How do I omit the duplicate values in the portal to show only a list of courses done?

[HPage]

Does nobody have an answer?

[Inky Phil]

I asked a similiar (although I am not sure the same) question here

http://fmforums.com/forum/showtopic.php?tid/180714/post/223126/hl//

Phil

[comment]

If you re-define the portal to show records from Courses, it should do what you want.