Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain actions when a primary key field in a primary key-foreign key relationship is updated or ...
I've been doing some work in MS Access (it's what I have and what I know) basically rolling my own Bill Of Materials database. Assemblies, subassemblies, individual parts. Relatively straightforward ...