I have a table with our store numbers vendor numbers as data for rows and beer brands as the headers. I also have a drop down list where I can select...
The strongest argument for having small lookup tables is this:
With an ongoing database, what if you want to change an existing salutation from, say...
(Having a separate primary key for a tiny table seems like a really odd thing to do... If it's only a handful of values, why not just store the real...
No you are not wrong, Access SQL is not case sensitive. T-SQL can be if you use the right syntax (Collate I seem to recall) but otherwise is also not...