How can I query and access a specific field on Contacts to then help me populate a Visualforce page I have on the Account?
I have a Visualforce page on my Contact that simply displays an alert if our field "Special_Care_Comments__c" is not blank.
I'd like to roll this up to the Account level too. So, if any Contact on the Account has their "Special_Care_Comments__c" field filled in, I want to display the same type of simple alert popup on the Account.
This is my Contact VF page:
How can I query all Contacts belonging to the Account, and, if possible, concatenate the values in this special care comments field to display in the alert popup?