I need to build a vendor search to provide a list of all the vendors and then a field to show the last transaction date for those vendors but I can't figure out what field to use. I tried Last Modified but that's not giving me the last transaction date, just the last time the vendor was touched. Anyone have an idea as to what results field I should use? I feel like I need to use a Transaction field with Date but to only display the most recent it would probably have to be a formula and I'm not sure how to write that.