Lookup Tables

Parent Previous Next

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.