Find based on multiple rows in a portal

[neilticktin]

I'm thinking that I'm just looking at this all wrong ... but let's see how folks chime in.

 

Two tables -- people and registrations (assume registrations can be the values A-F).  Relationship via a "People ID"

 

The people layout has a portal that shows all the registrations for that person in the portal.

 

I want to do a find that has all the people that have registration A and registration F.  In other words, they cannot have just A or F, but need both.

 

Since you can only search on one portal row for the record, and multiple finds requests are an "OR" not an "AND" -- what's the best way to do this?  (Note: There's a lot more than A-F, and there's more complexity and a lot of options -- I just distilled it down in this way to make it simple.)

 

Thanks!

 

Neil

 

[comment]

Start by finding the A's, then constrain the found set by finding the F's.