How can you use a value in a List View to look up information stored in another SmartObject?  Each row in a List View has a column value that we want to do a lookup on in order to get related information which we can then show in another column on the same row.

Specific information:

We are leveraging the 'Activity Instance Destination' SmO to show a list of tasks and statuses in a View.  The 'Destination' column (once trimmed) provides us with the Username of the person who has actioned a task.  We want to take that value and get the Display Name, etc. from an Active Directory SmO that we are already using in other Views.  For some reason we cannot set up a Rule that takes the 'Destination' value of each row, does a lookup, and sets an extra column on the row named 'Display Name'.  Has anyone been able to get this working with the same SmO or in a similar situation?

Thanks!