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?