Apologies, I'm new. I have a database in FM7. I would like to exclude some records from showing up in a portal, but have those records that don't show, appear in a portal on the same page.

Basically, we send out STUDENTS assigned to a SITEGUIDE to make VISITS to different SITES, one table for each.

Anyway, there are different kinds of visits, but they all are recorded in the VISITS table--each record has a VisitID, StudentID, SiteGuideID, SiteID (pulled from SITEGUIDE).

What I want is something akin to 'Show all Visits except attribute:TypeOfVisit="Special" in the first portal; in the second portal show ONLY Visit records where attribute:TypeOfVisit="Special".

Is this possible in FM7? It is important that I keep ALL visits in the VISITS table even though I need it to appear to users as if there are Special visits separate from all of the other types of visits. Thanks in advance.

Basically, you want to have two relationships: one for NotSpecial visits and one for special visits.

Lets say that your leftside of the relationship is Student, create a constant calc field: k_SPECIAL where the calc = "Special" (text)

Now in the Relations diagram

you should have the Students Table Occurance (TO).

Make sure you have 2 more TOs, say, "VS#Special" and "VS#notSpecial" (my naming method is AbbrevforTO#NatureOfrelationship

1) relate Students to VS#Special on Students::k_Special=VS#Special::TypeOfVisit

2) relate Students to VS#notSpecial on Students::k_Special<>VS#Special::TypeOfVisit (using the notequal symbol)

Now you can add portals to each on your layout

Does this answer?

Awesome, thanks!