I am designing a Windows Forms application in Visual C#2008 Express. My main DOCS table contains several integer type fields that refer to various types of metadata. For example, I have a Status field that may contain the integer 39 which is the ID of the metadata item called "Active" stored in my metadata table.

How do I display the word "Active" instead of the integer 39 on my Windows forms? I may want to display this in a grid column, a textbox, or even a label. I have several different integer fields in my DOCS table that represent different metadata that is stored in my METADATA table. I will need to use this functionality all through my application.

Thank you.