Filtering Portal Records with Duplicate Values
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.