I probably am, but - hey - I'm not the database programmer in this project, far less the lead design authority.  I'm just the business tier programmer trying to find out how...

No, we certainly wouldn't want to let customers modify FKs on installation.

However, the original requirement is inescapable (and - in our market context - not individually chargeable for).

The duplication of...

Thank you Mike

Essentially I am talking about a couple of columns for which the customer defines valid values.

Certainly defining a separate table to hold the valid values for each such...

I'm fairly sure I met this class of design in the early nineties where it was introduced to me as a CLUTs (Combined Look Up Tables) table.

As it is clearly...