AnsweredAssumed Answered

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

Question asked by MorkAfur on Feb 4, 2015
Latest reply on Jan 29, 2017 by beverly


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


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


Thanks in advance,

- m