I could not have said it better myself.

I wear two hats in my company. I am the lead programmer and the DBA. There is a big debate on this issue in forums like ASP.NET. As...

Your design is different then I expected (I'd say better). In my design I had two tables that had the following fields:

StatusMain - StatusMainID (Identity), TypeCode, Description

StatusSub...

Thanks. I am not using inheritance for my lookup tables. I use a static class that has 2 methods.

GetByPrimaryKey(string lookupType, objectKey)

GetAll(string lookupType)

The first method returns what I...

Thanks for the advice. I was not 100% sure that I had a handle on this. Unfortunately in my company, I am the System architect, Lead Programmer and DBA....

You may not be an OO or .NET expert but you hit on my design very quickly. While I use many status tables in the database, I only use...

Thanks for the help on this topic (I would have responded earlier, but I am on jury duty so I am in and out of the office). I was...

Thanks for the advice.

Option 2 sounds workable.

I had originally created the following tables:

CustomerStatus

VendorStatus

OrderStatus

Each table only held the rows that were applicable to that table. My boss thought that it was...

Based on your response I have a feeling that my example may have been a little confusing. Here is that same example that have hopefully made a little clearer.

I...