I made a mistake on a statement I just posted.

In access, I can create a lookup on a numeric table and still have the ability to store a text/character data type back to the table.