I’m creating a sort of message center that receives messages from records being added in other apps. In my top menu I’m using the macro to create a menu link which displays different icons for read and unread messages. In my message table I have a flag for read where yes = 1 and no = 0. The menu icons change depending on the flag.
My issue is that I can only read the flag for the first record and not any others. If the first record is flagged as read then the if statement changing the menu item only evaluates the first record. I’ve tried datasets and pure PHP arrays in a while loop but it still only evaluates the first record in the array. I will need to be able to execute the if statement for records that will exist in the future. I need a different approach or help understanding the correct logic.