AnsweredAssumed Answered

List Report related fields issue

Question asked by aammondd on May 21, 2010
Latest reply on May 25, 2010 by philmodjunk


List Report related fields issue


I know I know how to do this but I have a cold at the moment and something is not working right so I need some clear headed help


I have a customer table and a customer notes table the notes table has a notes type field the notes have an auto enter creation and modified date fields


I want to display a list of customers and only the most recent related note (if any of a particular type) I was trying to do this by creating a relationship between the  notes table and a global field that was equal to the type and then just displaying the related field with the relationship sorted descending by date last updated.


Im getting other note types displayed right now I dont have a clear head so can someone help me where did I go wrong. Do I need a portal for the related fields?