HELP!!!!! Portal restriction
Okay I'm trying to get a portal to only show records that do not contain part of a string in another field.
So if in a record, a text field named Author contains "George, H. G. and Patterson, C. D."
I want the portal to compare text in the text field ::CAuthor and not display portal records that contain any of the text from either field. So if ::CAuthor contains "George" or "Patterson" or a combination of George plus other text or Patterson and other text it will not be present in the portal. Any ideas?