1 Reply Latest reply on Jan 9, 2013 1:23 PM by taylorsharpe

    Field with list of text from found records

    strngr12

      Hello!

       

      I have a field with a text value and I need to have another summary field that displays a list of the values only from found records.

       

      For example, Lets says they are names:

       

      Dave Johnson

      Dave Smith

      Dave Williams

      John Jackson

      Bill Brown

       

      The summary field should display (format is unimportant for the moment):

       

      Dave Johnson

      Dave Smith

      Dave Williams

      John Jackson

      Bill Brown

       

       

      But if I do a search for "Dave" I want the field to display:

       

      Dave Johnson

      Dave Smith

      Dave Williams

       

      And if I do a search for "Bill" I want the field to display:

       

      Bill Brown

       

      Can anyone tell me how to do this?

       

      Thanks!

        • 1. Re: Field with list of text from found records
          taylorsharpe

          This would be a perfect example of when a related table is better than repeating fields.  Why don't you make a separate table with the names in them related to the first table?  You then can have either a list or portal that does a find/filter as you describe.  Tell us more about your schema?  What defines a record that has this field with multiple names?