Say I have a relationship between two tables: 1) Colors and 2) Shirts. One Color to many Shirts. If I want to record a new Shirt, I must select its Color.
Each Color has a status: New, Old, Retired. When I a user records a new Shirt, is it possible to limit the choice of Color to those without the Retired status?