I'm designing a table to track programitic changes (rudimentary version control). One of the fields will be one of three types of language: we currently deal with: PL/SQL, VBA, PowerBasic.
Typically I would have another table with a unique Type_key and a description. I would then use the Type_id in the main table.
Because the list is so limited, it would be more practicle to have a "drop down" field where the acceptable values would be "hard coded" to avoid mis-spellings.
Is something like this possible, or, is there anything I can do to accomplish this without creating yet another lookup table?