I have a news page type that makes use of two gridfield elements.
One is Categories, the other is Articles.
The Categories is working fine in the sense that you can add remove etc.. No problems here.
The Articles additions works fine also, it's just the displaying of the Articles GridField that would otherwise confuse users.
When an article is created, a user is given a dropdown to select the assigned category, which saves the ID of the Category from the DB into the record for the article, which allows the category name to be changed in the future without affecting articles assigned to it...
The confusing part is when the user then views all of their Articles, they can see the article name, and the assigned category comes up as the ID.. How can I make that particular column fetch its value based on the actual category name within the Categories table as opposed to the ID? - It would involve a SQL query, which is fine, but I don't know how to alter the values in the displayed output of the Grid.