I am working on filtering a portal by a specific field. I have a table named "properties" and a field named "status". I am trying to have a portal that shows just properties where the Status=Under Contract. I created a relationship linked to the same table. Now I have a portal with a filter formula that = Properties 2::Status = "Under contract".
It works when I have one record selected with a status of "under contract" but when I have 2 or more, the portal just duplicates the first record. I end up with 2 of the same records in the portal.
I forgot to mention the status field is a drop down with different choices.
any help would be great. Thanks!