Using Sharepoint Lists to Manage Master Data (Lookups)

A common need for any development project is to create an administration module and set of CRUD(Create, Read, Update, Delete) screens to service master data - lookups.

Why not use SharePoint to manage this data, after all SharePoint is just like any other database, with tables full of columns (lists). The beauty with using SharePoint lists to manage master data is that SharePoint already has screens to allow users to create and maintain this data, with a very comprehensive security model ready to go out-of-the-box.

So lets look at an example ...