Show Unique Records only In a found set script
In a found set I have all the records that match the search I have set. However, each record layout has a portal within it. E.g. A company sells pens, but in the portal it lists pens twice as they are from different brands.
In the found set if a search for pens was made, it shows the company twice in the found set. I want the company to only appear once. Please note the fields in the results page is from two different tables, e.g. the name is from one table (which is the uniqueid) and the email address / phone number are on another table.
I have tried to constrain the found set with a ! but still no luck.