Is there a way to enforce one-to-many relationship with cascading updates without requiring the related table to have a related record? For example, how can I get a one-to-many relationship on [tbl_Colors].[Color_Name] (one-side) and [tbl_Cars].[Color_Name] (many-side) without every record in tbl_Cars having a related record in tbl_Colors?
What I'm wanting to do is ensure that if a [tbl_Colors].[Color_Name] record is ever changed/renamed (ie: from "Red/Brown" to "Maroon") , then the change is replicated to all other tables that are joined to [tbl_Colors].[Color_Name]. But, not every related record is going to have a Color_Name specified.
What I'm wanting to do is ensure that if a [tbl_Colors].[Color_Name] record is ever changed/renamed (ie: from "Red/Brown" to "Maroon") , then the change is replicated to all other tables that are joined to [tbl_Colors].[Color_Name]. But, not every related record is going to have a Color_Name specified.