Home » Questions » Computers [ Ask a new question ]

Can you associate a meaning to each value in Access 2007?

Can you associate a meaning to each value in Access 2007?

How do I store numbers in an Access column and then associate some meaningful string to each value?

Asked by: Guest | Views: 74
Total answers/comments: 1
Guest [Entry]

"You need to create a table which contains the relevant values for each number. Then simply create a relationship between the primary table and the secondary table. This would be the simplest and correct way of doing. However I have to admit I can't remember step by step how to do this in Access. However Microsoft has a fairly good article on how to do this here.

As far as the display is concerned you will create a new data view that retrieves the display value instead of the number and link everything to the view.

I am not aware of any other way to do this in Access."