• Ok, I am sorry - not really - but this is design madness. 

    Seperate tables for each lookup table.  Surrogate int keys when appropriate (almost always).  This keeps referential integrity possible - hello thats the point of a relational database.

    ISO codes - give them a column with a unique constraint.

    Never, never, never design anything that uses triggers for referential integrity unless it is as a last resort.

    I want my lookup tables to be easy to use

    Select F.Comments, S.StatusCode

    From Form F

    Join Status S

    On F.StatusID = S.StatusID

    Where F.FormID = 34567

    There, I have comment and the text version of the status information, something the user can read.

    Also, if I want to cache Status Code information somewhere the table is small and light so it is easy to cache as say XML


    Michael R. Schmidt
    Developer