AnsweredAssumed Answered

Filtering Portal Records with Duplicate Values

Question asked by Robbie_1 on Feb 7, 2015
Latest reply on Feb 16, 2015 by Robbie_1

Title

Filtering Portal Records with Duplicate Values

Post

Hi, 

I am trying to set up a portal that filters out records that display duplicate values in a specific set of fields, displaying only one record per unique set of fields. Here's my best shot at an example of what I need to do...

Table 1 contains master record and portal

Table 2 contains records 1, 2, and 3

Records 1, 2, and 3 contain fields 1, 2, and 3. 

If Field 1, Field 2, and Field 3 are identical, I would like for the portal in Table 1 to only display Field 1, Field 2, and Field 3 once (In other words, only displaying Record 1, Record 2, or Record 3).

In this case it does not matter if the actual record displayed in the portal is Record 1, Record 2, or Record 3. 

Thank you in advance for the help. 

Robbie

Outcomes