sandyinlet Posted May 11, 2010 Posted May 11, 2010 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
sandyinlet Posted May 11, 2010 Author Posted May 11, 2010 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.
Recommended Posts
This topic is 5645 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now