May 11, 201015 yr Contact records store their phone numbers in a related Phones table. While in the Contacts table I'd like a scripted solution for reducing the current found set to just those without any records in the Phones portal. Yes, the script could loop through each record doing a test for not isvalid(Phones portal relationship), store the current Contact ID in an accumulating variable, then do a GTRR on that variable's list of Contact IDs. Is there something more efficient that does not involve looping? I suspect there must be but haven't discovered one yet. Any ideas? Much appreciated
May 11, 201015 yr Author Found the answer to my own question. Execute a Constrain Found Set script step. Configure it to omit records which have Phone portal relationship::SerialID > 1 Sometimes writing out the problem and submitting it to a forum jiggles the mind to spontaneously come up with the answer. Thanks.
Create an account or sign in to comment