1 Reply Latest reply on Oct 13, 2009 9:52 AM by philmodjunk

    Finding records by way of portal fields



      Finding records by way of portal fields


      I have File One related to multiple records in File Two.  I would like to search for records in File One that have specific text in multiple records in File Two.  For example: File One has names of items sold.  File Two has comments about each item, including notes when users have problems with an item.  I want to find items in File One where more than one user has complained about an item.


      If I do a search in the portal, I can only type in one row.  Is there a way to type multiple requests in the portal?





        • 1. Re: Finding records by way of portal fields

          Yes, but I don't think it will return the results you want. When you enter search criteria into a portal while in find mode, you are telling filemaker "Find all records in table 1 that have at least one related portal record that matches this criteria." You can select New Request to enter a second criterion in the portal, but then you are saying Find all records in field one with related portal records matching Criteria 1 OR Criteria 2---so this still doesn't produce what you want.


          Perhaps a different approach will work:


          Switch to a layout based on your portal records. Perform your find on this layout and sort by your key field to group the records by product in descending order. You can omit records off the bottom of the list to remove records that are too infrequent to be of interest. You can now use Go To Related Records, Match all records in current found set in a script, to locate the product records on your original table/layout.


          Note: Go To Related Records is complex, with many undocumented features/issues. See this thread for a complete run down on this powerful tool:

          The Complete Go To Related Record