Lookup Tables

Lookup tables are simple in nature, tend to have a small number of fields and contain static (rarely updated) values and never contain foreign keys.

1. Prefix lookup tables with “lk_” as in “lk_countries”.
   
   Reason: This makes lookup tables easy to find when assigning tables to lookup or dropdown controls.
   
   
2. If useful, include a field named "Inactive" as a logical field. Set this to True to hide record in lists.