11 Replies Latest reply on Jan 29, 2017 6:55 AM by beverly

    How to get nice tool tip list of related history items?

    MorkAfur

      Title

      How to get nice tool tip list of related history items?

      Post

      I have a MEMBER table and a child, related, MEMBERSHIP_PAYMENTS.

      In the member table, I would like to be able to hover over the last payment date field and have it pop up in a tool tip a nice looking list of all previous amounts and also payments.

      Using the "List()" function, it only seems to give me all the related field rows if I only use one field. If I use two fields then it only gives me one row with one value of each of the fields.

      I tried ExecuteSQL, but then it isn't formatted nicely -- there are no column headings, for example, and spacing is too tight.

      ---

      So, what's the best way to get multiple fields to display all their history records in a tooltip and have nice headings, spacing, and such?

      Something like (fields below from payment history table):

      Last Payment      Payment Amount
      ------------------------------------------------

      1/1/15                     $100

      12/1/14                  $50

      11/1/14                   $75

      etc.
       

      Thanks in advance,

      - m