• For reference tables, I use a suffix of "Lookup".  Had I to do it over again, I would have used a special prefix instead so that the lookup tables would sort as a group.  However, the suffix does make the function of the table very clear. 

    Almost all of our lookup tables have two fields (three at the most), usually just a key and a description.  If the table has any function other than a lookup, it's not considered a reference table.



    Dana
    Connecticut, USA
    Dana