Finding in portals

[Kmcgrath]

How do you narrow a find within a portal? I've related a student table to a class table and the middle table is enrollment. So enrollment contains all the classes each student is taking. Very simple. So, I have a portal in the student table which views all their classes. But, when I try to find just some of those classes (just one quarter's classes), I still get them all. Any clues?

[RalphL]

I assume the records in enrollment have a field for the quarter. Add a global field gQuarter to the Student table. Make another TO for enrollment. Make a relationship Student ID = Student ID AND gQuarter = Quarter. Make a portal for this relationship, maybe on a new layout.

[Reed]

One thing you could do, is add a field to the enrollment join table that indicates which quarter the enrollment is for (It could also be a date field) Then add that to your relationship criteria. Use a global in the student table to input the proper quarter/date. Then the portal will only show records that match.

You could also use two date fields and the greater/less than operators to show a range of dates.

Dana

[Kmcgrath]

Great answers. I did it and it worked! However, I noticed that this does only work for one quarter at a time. In order to find two quarters at the same time, I'd have to use a date range.

Before I got your answers, I went back to my "flat" thinking and just did my find from the join table, which works like I am used to. At this point that seems easier.