I want to exclude records in a Portal...

[OnTheOutside]

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.

[smorr]

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?

[OnTheOutside]

Awesome, thanks!