I am developing a 3-tier application with a VFP DBC as the data source, VB as the middle tier, and ASP as the presentation layer. The database tables use many coded values. My question is where do I put the decoded values?

I can create code tables in the DBC and have my data layer pass up the decoded values to the business logic layer. Or, I can pass up the coded value from the data layer and let the business logic decode it.

Right now, I am only displaying info from the database, but later we will allow updates. I would think I should create decode tables. Does anyone have any thoughts?