How to create Access 2013 field with only 2 possible values
Posted on 2014-12-31
I have a really simple question. I just need to create a field in a table that will track whether a job opening record requires a Lebenslauf auf Deutsch (German resume) or an English one. I want to be able to choose "Deutsch" or "English" (English is default), but have DE or EN recorded in the database. This field represents a flag for a mail-merge effort to automate cover letter customization -- I want to be able to run the merge for just one language based on a query of this field.
I know it's simple, but you'd be surprised how difficult it is to find this kind of info through a search engine. (Either that, or I'm not very good building search engine queries...)
Thanks in advance.
P.S. I thought about building a lookup table, but it seemed to be overkill for just 2 languages. Is that a correct assessment, or would it be a good approach after all?