2 Replies Latest reply on Aug 16, 2014 1:52 PM by philmodjunk

    Find based on multiple rows in a portal



      Find based on multiple rows in a portal


           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.)