Using CR11 and trying to display notes for an organisation which has contacts
for example, at organsation ABC i met with contact1,contact2,contact3 and the note for that meeting
at the moment its displaying
ABC contact1 "the note"
ABC contact2 "the note"
ABC contact3 "the note"
the way i want it is
ACB Contact1,contact2,contact3 "the note"
This was fine when Select Distinct records was working, at the moment when i select it, i get this error
"Failed to retrive data from the database"
is there any other way to achieve this