November 23, 200619 yr 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?
November 24, 200619 yr 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
November 24, 200619 yr If you re-define the portal to show records from Courses, it should do what you want.
Create an account or sign in to comment