Have Portal Show Unique Records

[dcgall]

I would like a portal to show records based on unique fields. Is this possible? example, my data:

 

ST1, GR1, Unit1, Lesson1

ST1, GR1, Unit1, Lesson2

ST1, GR1, Unit1, Lesson3

 

ST1, GR2, Unit2, Lesson1

ST1, GR2, Unit2, Lesson2

ST1, GR2, Unit2, Lesson3

 

ST1, GR3, Unit3, Lesson1

ST1, GR3, Unit3, Lesson2

ST1, GR3, Unit3, Lesson3

 

I would like only this in the portal:

 

ST1, GR1, Unit1

ST1, GR2, Unit2

ST1, GR3, Unit3

 

It's basically filtering out the Lessons. thanks,

[AHunter3]

Not in a portal, no.

 

You can generate a VALUE LIST that does that.

[YMD]

If you have another table that maintains the desired values and display that in the portal, yes

 

Assuming from your example, that you are looking from a student record, to lessons which are for a specific course.

 

In your relationship graph you will need the following

 

Table Student related to Table Lesson by Student ID

Table Lesson related to Table Course by Course ID

 

From a Layout based on student, create a portal based on the Table Course. This will give you a portal showing all courses for which the student has a lesson.