I am attempting to generate a Search where I list all items and a column showing the last date they appeared on either a Sales Order, Invoice or Cash Sale.  If they have never appeared on one the column should be empty - but the item should still appear.  So the search should return the same number of records as a straight up item list.

I can't seem to tease this information out and am starting to go cross eyed so I am wondering if there are any search experts who have done something like this?

- Mike