• I too use a spookily similar table and have found it very effective. In particular moving new LookUps from dev to live is now very simple.

    Small differences are that I have both a varchar and int field for the data part of the lookup and then use either or both of them.

    I don't currently use the Const field which I shall now try, to aid readability.