I have a portal currently showing all matching records related to the main record being viewed.
The table with the matching records includes a "Status" field indicating whether the record is "Active" or "Inactive".
I would like to provide the ability to select and show the matching portal records according to the following possibilities:
1) show "All", allowing the portal to show all matching records (i.e. regardless of "Active" or "Inactive" status),
2) show "Active", limiting the portal to show only those matching records that are "Active"
3) show "Inactive", limiting the portal to show only those matching records that are "Inactive"
While I have been able to filter the portal using a global field in the main table that can be set to either "Active" or "Inactive" (accomplishing 2 and 3 above), I have not been able to accomplish 1 above. Ideally, I would like to provide the option "All" in the global field, to show all matching records in the portal, regardless of the record status.
Thank you in advance,