3 Replies Latest reply on Apr 16, 2010 1:02 PM by k1ngf1sher

    Combine text data from related tables

    k1ngf1sher

      Title

      Combine text data from related tables

      Post

      Hi all, I am trying to combine text data from the same field but across multiple records.  I would like this 'summary' field to work as one might do when creating a summary calculation using a self-join relationship, but, and here's the rub,  I do not want to create a summary report or use a portal.  This might sound like a strange request, but it's necessary for my client's goals.

       

      The exact situation is this: 2 tables, Storage and Storage2, are self-joined by ID and Include(Yes or No).  The field I want to combine between related records is called 'Source.'  When I have two records that have the same ID and same Include response ('Yes'), then I would like the two records to each the same text value in a third variable, Source_Summary, that is a combination of their respective 'Sources'.  It would be nice to place a semicolon between each record (if that's possible).

       

      Any suggestions would be greatly appreciated.

      K