My main file is SURVEYS. A base table within that file is called SURVEYS. It is linked to an external data source (FMP file stored on local drive) called ORGS via unique ORG_ID. ORGS contains all customers. SURVEYS contains customer satisfaction surveys received from a subset of ORGS.
I want to create a layout in SURVEYS based on ORGS to display all SURVEYS received from companies that have submitted one or more SURVEYS.
I created a layout in SURVEYS to show records from ORGS and I added a portal showing related records from SURVEYS.
How can I filter the found set to show only those that have submitted one or more SURVEYS?